| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems calculating total hours | Excel Discussion (Misc queries) | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| Need help with conditional rates and roster times for payroll | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Linear Mode
