Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time calculations Urgent please help
I am trying to get this result in excel 22:00 to 02:00 =4 22:00 to 03:30 = 5.5 Can anyone help me with this please Thanks in advance -- colt |
#2
|
|||
|
|||
colt Wrote: I am trying to get this result in excel 22:00 to 02:00 =4 22:00 to 03:30 = 5.5 Can anyone help me with this please Thanks in advance If 22:00 is in A1 and 2:00 is in B1 then this would work if you format the cell it is in to a Time format of hh:mm: =IF(A1B1,B1-A1+24,B1-A1) -- jahoobob |
#3
|
|||
|
|||
colt Wrote: I am trying to get this result in excel 22:00 to 02:00 =4 22:00 to 03:30 = 5.5 Can anyone help me with this please Thanks in advance In your illustration, if 22:00 is in A1 and 02:00 is in B1 then this formula will get your desired reslut: =IF(A1B1,((B1-A1)*24)+24,(B1-A1)*24) -- jahoobob |
#4
|
|||
|
|||
Colt,
With 22:00 in A1 and 02:00 in B1, try: =B1-A1+(A1B1) or if you want the answer in real numbers: =(B1-A1+(A1B1))*24 and format the cell as General or Number An alternative would be: =MOD(B1-A1,1) for time or =MOD(B1-A1,1)*24 for a General number -- HTH Sandy Replace@mailinator with @tiscali.co.uk "colt" wrote in message ... I am trying to get this result in excel 22:00 to 02:00 =4 22:00 to 03:30 = 5.5 Can anyone help me with this please Thanks in advance -- colt |
#5
|
|||
|
|||
try using the "time" function on your existing numbers
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
'Time to Fix' Formula | Excel Discussion (Misc queries) | |||
Time Calculations | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
Date and time calculations | Excel Discussion (Misc queries) |