Y
Yogin
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
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