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

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

On Thu, 16 Dec 2004 19:29:02 -0800, "Mico"
wrote:

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

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" wrote:

On Thu, 16 Dec 2004 19:29:02 -0800, "Mico"
wrote:

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