Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i calculate time after midnite "01/12/05 13:00 to 01/13/05
Example 01/12/05 13:00 to 01/13/05 02:00 should = 13 hours
problems with time |
#2
|
|||
|
|||
Hi
With Start date in A2 and end date in B2 =B2-A2+(B2<A2) formatted as "hh:mm" or "h" When you want the number of hours, then =(B2-A2+(B2<A2))*24 -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "highball" wrote in message ... Example 01/12/05 13:00 to 01/13/05 02:00 should = 13 hours problems with time |
#3
|
|||
|
|||
Start time in A1,
End time in B1, Enter this formula in a cell formatted as "General" or "Number": =(B1-A1+(B1<A1))*24*AND(A1<0,B1<0) Both A1 and B1 must have times entered for this to work. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "highball" wrote in message ... Example 01/12/05 13:00 to 01/13/05 02:00 should = 13 hours problems with time |
#4
|
|||
|
|||
Works great thank Ragdyer.
"RagDyeR" wrote: Start time in A1, End time in B1, Enter this formula in a cell formatted as "General" or "Number": =(B1-A1+(B1<A1))*24*AND(A1<0,B1<0) Both A1 and B1 must have times entered for this to work. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "highball" wrote in message ... Example 01/12/05 13:00 to 01/13/05 02:00 should = 13 hours problems with time |
#5
|
|||
|
|||
Appreciate the feed-back.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "highball" wrote in message ... Works great thank Ragdyer. "RagDyeR" wrote: Start time in A1, End time in B1, Enter this formula in a cell formatted as "General" or "Number": =(B1-A1+(B1<A1))*24*AND(A1<0,B1<0) Both A1 and B1 must have times entered for this to work. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "highball" wrote in message ... Example 01/12/05 13:00 to 01/13/05 02:00 should = 13 hours problems with time |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate time difference to the half hour | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
formula to calculate a time sheet | Excel Worksheet Functions | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) |