How do I sum times to get a total hour value? If I add up to 24 h.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a timesheet that totals daily hours then totals those
hours. When the sub totals raech 24 they displayed total shows as 0 instead
of 24. Thus a 40 hour week shows as 16 (40 - 24) . Any help willl be
appreciated.. Michael
 
I am trying to create a timesheet that totals daily hours then totals those
hours. When the sub totals raech 24 they displayed total shows as 0 instead
of 24. Thus a 40 hour week shows as 16 (40 - 24) . Any help willl be
appreciated.. Michael
Click to expand...

Format the result as [h]:mm


--ron
 
Hi Ron , thank you very much. 1 more thing. How do I now show minutes as
hours? e.g. 30 mins as .5 hrs

Ron Rosenfeld said:
I am trying to create a timesheet that totals daily hours then totals those
hours. When the sub totals raech 24 they displayed total shows as 0 instead
of 24. Thus a 40 hour week shows as 16 (40 - 24) . Any help willl be
appreciated.. Michael
Click to expand...

Format the result as [h]:mm


--ron
Click to expand...
 
Back
Top