Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Calculation
Hello experts,
Question on how to add hours to a time... E.g., I have a time in A1 (let's say 6:06 AM) I want to add an amount to A1 (let's say 8.5 hrs in cell B1) My formula in C1 = A1+ Time(B1,30,0) [i'm adding a half hour for lunch] My formula returns 2:36 PM, I want it to return 3:06 PM (6:06 AM plus 8.5 hrs plus 30 minutes). This formula works well when the amount in B1 is an integer (I know this is obvious because the Time function reads Time(hour, minute, second). I need a way to calculate a partial hour. I'd like this formula to remain dynamic; i.e., allowing me to dump my start time in one cell, my hours (any hour(s)) in another cell, and my ending hours in the final cell. Keep in mind the time in A1 will change daily, as well as the hours in cell B1; the 30 min for lunch, however, will not. Thoughts? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop time - start time calculation | Excel Worksheet Functions | |||
Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
time calculation with military time | Excel Worksheet Functions | |||
Time calculation. | Excel Worksheet Functions |