| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time formulas
Thanks again.
"Peo Sjoblom" wrote: If you are going to use decimal values you need to format the result as General or number, not time -- Regards, Peo Sjoblom "Blazingsaddles" wrote in message ... Ugh! What am I doing wrong? C10 is 12:00 am with this formula. Thanks. "T. Valko" wrote: Try this: =(MOD(C7-C6,1)+MOD(C9-C8,1))*24 -- Biff Microsoft Excel MVP "Blazingsaddles" wrote in message ... Here is my timesheet: c6: 11:00 pm c7: 12:00 am c8: 7:00 am c9: 3:00 pm c10: (Actual hours worked) If I use the formula: =IF(C6C7,C7+1-C6,C7-C6)*24 I can get the time for c6/c7, but what formula do I use to not only get the hours from c6/c7, but also from c8/c9 - to get the total of 9 hours in c10? Thanks, I appreciate any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Formulas | Excel Discussion (Misc queries) | |||
| Using Time in Formulas | Excel Discussion (Misc queries) | |||
| Time Formulas | Excel Discussion (Misc queries) | |||
| Time Formulas | Excel Discussion (Misc queries) | |||
| Time formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
