Getting Time difference

[Dhruva101]

Start time End time Run Time

14.42.52 14.43.26 #VALUE!
07.17.57 07.18.00

In the Run time column I need the difference between end-time and start-time. All three columns are formatted to category - TIME. I put in the formula on Run time column as =TEXT(E4-D4,"h:mm:ss"). This formula is not resolving the time difference, can some one help in this ?

[VBA Noob]

Hi,

You should need to use the Text Function.

I just did the below.

I did have to re-enter your figures as HH:MM:SS first

=IF((D4-E4)<0,E4-D4,D4-E4)

VBA Noob

[Dhruva101]

I just tried this IF((D4-E4)<0,E4-D4,D4-E4), Still getting error #VALUE!, Any more ideas ?

[daddylonglegs]

Excel won't normally recognise 14.42.52 as a time.

If you input times with colons, i.e. as 14:42:52 then for the time difference use the formula

=E4-D4+(D4>E4)

format result cell as time, e.g. hh:mm:ss

otherwise if you retain the format of 14.42.52 you can use this formula for the time difference

=MOD(SUBSTITUTE(E4,".",":")-SUBSTITUTE(D4,".",":"),1)

again, format result cel as a time

[Dhruva101]

Thank you Daddy, this works great ...