Is the "1.15" one hour and 15/100's or 1 hour and 15 minutes, 1:15?
What script are you currently using?
When you calculate the elapsed time using a given unit are them formatting back into hours and minutes, hh:MM, or just hours?
The 1:15 is 1 hour and 15min
I am currently not using a script, I cant get it to work
I want the formatting to be H:M and not just hours, so if it is 2.75 hours (hence start time of 12:00 and end time of 14:45 then it must calculate 2.75 hours)
Then how are getting it to calculate?
Date arithmetic provides one approach to the problem but does not address the custom formatting of the result. There are also a number of ways to convert just the time string to a single numeric value that does not use the date object.
Unless you are very experienced in programming, I would first work out getting the elapsed time to calculate. Then tackle the formatting issue. Then I would tackle the computation of overtime. There is more than one definition of what overtime is. It can be work time of more than 8 hours in anyone day or work time over 40 hours for one week.
Thank you for pointing me in the right direction
I found an article that solved my problem