Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a formula that calculates time.
The following cells contain the following data. Cell B381 contains 8:00 AM Cell C381 contains 4:45 PM Cell E381 contains =TEXT(C381-B381-TIME(,30,),"[h] \h\r\s: m \m\i\n\s") which calculates to 8 hrs: 15 mins. In cell G381, I want to display the time from cell E381 as 8.25 What formula do I use in G381? Any help would be greatly appreciated Thank you for your time in advance, Karen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 | Excel Worksheet Functions | |||
time calculation with military time | Excel Worksheet Functions |