| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time question
I need a formula that would figure out what time it would have to be to
complete a 40 hour week The information I have to plug in is this. Current total hours - 37 hrs 32 mins Current time is - 12:39 pm What time does it have to be to complete 40 hours? Seems like it should be simple but.... -- gueyo |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time question
A1: 37:32:00
B1: 40:00:00 C1: 12:39 PM D1: =C1+(B1-A1) -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "gueyo" wrote: I need a formula that would figure out what time it would have to be to complete a 40 hour week The information I have to plug in is this. Current total hours - 37 hrs 32 mins Current time is - 12:39 pm What time does it have to be to complete 40 hours? Seems like it should be simple but.... -- gueyo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i need more help with this time question | Excel Discussion (Misc queries) | |||
| Time Question | Excel Worksheet Functions | |||
| Time Question | Excel Discussion (Misc queries) | |||
| time question | Excel Discussion (Misc queries) | |||
| Time question | Excel Discussion (Misc queries) | |||
Linear Mode
