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

[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

 

[Ron Rosenfeld]

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

Format the result as [h]:mm


--ron

 

[Guest]

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

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

Format the result as [h]:mm


--ron