| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating time
i want to add up staff hours for the week but when it gets to 24 it starts
from zero again like a 24 hour clock |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculating time
Format Custom as [h]:mm
-- Kind regards, Niek Otten Microsoft MVP - Excel "shazbat61" wrote in message ... |i want to add up staff hours for the week but when it gets to 24 it starts | from zero again like a 24 hour clock |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculating time
See Chip Pearson's Date/Time arithmetic web page at the following URL:
http://www.cpearson.com/excel/datearith.htm -- Kevin Backmann "shazbat61" wrote: i want to add up staff hours for the week but when it gets to 24 it starts from zero again like a 24 hour clock |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculating time
i tried that but its not working i have 7:00 in cell b2 i have 11:00 in cell b3 = 4 hours thats is for monday in c 3 then i have the same in d 2 and d3 and e3 for tues and so on for the week i want to add up cells c3+e3+g3+i3+k3+m3+o3 = 28 hours but it is adding up to 4 hours "Kevin B" wrote: See Chip Pearson's Date/Time arithmetic web page at the following URL: http://www.cpearson.com/excel/datearith.htm -- Kevin Backmann "shazbat61" wrote: i want to add up staff hours for the week but when it gets to 24 it starts from zero again like a 24 hour clock |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculating time
Niek Otten gave you the solution more than an hour before your second post.
Just follow his advice, and it will solve your problem. Regards, Fred. "shazbat61" wrote in message ... i tried that but its not working i have 7:00 in cell b2 i have 11:00 in cell b3 = 4 hours thats is for monday in c 3 then i have the same in d 2 and d3 and e3 for tues and so on for the week i want to add up cells c3+e3+g3+i3+k3+m3+o3 = 28 hours but it is adding up to 4 hours "Kevin B" wrote: See Chip Pearson's Date/Time arithmetic web page at the following URL: http://www.cpearson.com/excel/datearith.htm -- Kevin Backmann "shazbat61" wrote: i want to add up staff hours for the week but when it gets to 24 it starts from zero again like a 24 hour clock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Regular time, overtime and double time | Excel Worksheet Functions | |||
| Calculating time and negative time | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Calculating effective time from start/end date+time | Excel Worksheet Functions | |||
Hybrid Mode
