Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formula
Hi,
i am having deficulty to add up 2 time data. I am copying this information from a web browser and pasting this onto excel. The format for the date is the following: 11:30 02/01/2009 i then use the following formula to omit the date so only the time is shown. =LEFT(Sheet1!E144,5). Which shows me the time as 11:30. What I am then trying to do is take depart time away from arrive to give me total journey time. I am using the following formula: =IF(E133<D133,(E133+1)-D133,E133-D133). This work fine for all time before midnight but I get an error for if one of the time is over midnight eg. 23:00 - 01:30. If I key in the time with using the LEFT formula then this works without any problems. Can someone help me please. Thanks Yogin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time formula returns night time by mistake | Excel Discussion (Misc queries) | |||
Calculating Time with Date/Time checking in formula | Excel Worksheet Functions | |||
formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel |