I have a timesheet type system which holds times in hours and minutes for time spent on different jobs. For example Job1 Start 09:00 Finish 10:15. There will be many of these records and Job1 will have lots of records against it.
I need to make a report which shows the total hours and minutes worked on Job1. Currently I total it up and it is formatted as short time but as soon as it totals to more that 24hours it will go around to 01:00, 02:00 etc.
How do I get it to calculate so the total could for example be 320Hours 19 Minutes?
Times are entered on the form as example Start Time 08:15 Finish Time 08:35. The total time is worked out by Finish Time minus Start Time example 08:35-08:15 gives us 00:20. However, it is not in the format 00:20 straight away it is stored as a number which in this case looks like 0.0138888888888889. If you then format that as short time or hh:nn it will show 00:20. It works ok for less than 24hrs but above that im not sure what to do.