| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Very Simple Time/Hour Question
If the time on A1 = 12/3/07 8:00 A.M
A2 = 2 (hours) On A3, what is the formula so if A1 + A2, it should show 12/3/07 10:00 A.M? If A2 = 24 (hours), A3 should show 12/4/07 8:00 A.M. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Very Simple Time/Hour Question
=A1+(A2/24)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Danny" wrote in message ... | If the time on A1 = 12/3/07 8:00 A.M | A2 = 2 (hours) | | On A3, what is the formula so if A1 + A2, it should show 12/3/07 10:00 A.M? | | If A2 = 24 (hours), A3 should show 12/4/07 8:00 A.M. | | Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Very Simple Time/Hour Question
Thanks a lot Niek. Have a great day!
"Niek Otten" wrote: =A1+(A2/24) -- Kind regards, Niek Otten Microsoft MVP - Excel "Danny" wrote in message ... | If the time on A1 = 12/3/07 8:00 A.M | A2 = 2 (hours) | | On A3, what is the formula so if A1 + A2, it should show 12/3/07 10:00 A.M? | | If A2 = 24 (hours), A3 should show 12/4/07 8:00 A.M. | | Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
| Question on Format in Hour & Minute | Excel Worksheet Functions | |||
| making a time a measurement of time, not an hour of the day?? | Excel Discussion (Misc queries) | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Linear Mode
