| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assistance with Time Keeping Formula
I use excel to manage complicated schedules. I put the starting and ending
times in military time, and then a formula to come up with the totoal hours. I use the following formula: =MOD(G476-E476,1)*24 But now, for some reason, the formula works in one instance, but not in another, and I cannot see why. Can anyone tell me what additional info I need to make this work in any spreadsheet I use? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Time formula | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| I have problems keeping the merge formula to use as a template. | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
