Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Q: Time Difference
Hello,
I need to find the difference between two time value as hours. I have two cells that keeps the time, so between 8:00am and 9:30am, it means 1.5 hours. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Q: Time Difference
Since XL stores times as fractional days, one way:
A1: 8:30 am B1: 9:30 am C1: =(B1-A1)*24 However, if there's a chance your times may span midnight (when the fractional day resets to 0), use C1: =MOD(B1-A1,1)*24 In article , JIM.H. wrote: Hello, I need to find the difference between two time value as hours. I have two cells that keeps the time, so between 8:00am and 9:30am, it means 1.5 hours. Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Q: Time Difference
hi,
that is a simple subtraction. if start time is in A1 and end time is in B1, formula in C1 would be.... =b1-a1 I'm using xp. worked for me. Regards FSt1 "JIM.H." wrote: Hello, I need to find the difference between two time value as hours. I have two cells that keeps the time, so between 8:00am and 9:30am, it means 1.5 hours. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Time Difference | Excel Discussion (Misc queries) | |||
Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
Time zone Time difference | Excel Worksheet Functions | |||
Time / Formula to look at time difference | Excel Worksheet Functions |