G
Guest
Hi,
I have a list that keeps track of how many hours/minutes per day someone has
worked (format "short date").
Now I want to calculate a total (the field is also format "short date") of
how many hours someone has worked. But of course when that total exceeds 24
hours, it starts back from 00:00. How can I avoid this?
Example:
day 1 08:00 hours
day 2 07:00 hours
day 3 08:30 hours
day 4 09:00 hours
day 5 09:00 hours
Total should be: 41:30 hours
AND NOT 17:30 which I get now
Thanx.
I have a list that keeps track of how many hours/minutes per day someone has
worked (format "short date").
Now I want to calculate a total (the field is also format "short date") of
how many hours someone has worked. But of course when that total exceeds 24
hours, it starts back from 00:00. How can I avoid this?
Example:
day 1 08:00 hours
day 2 07:00 hours
day 3 08:30 hours
day 4 09:00 hours
day 5 09:00 hours
Total should be: 41:30 hours
AND NOT 17:30 which I get now
Thanx.