PDA

View Full Version : Time calculation with Excel



arrun
12-24-2012, 02:20 AM
Dear all, I am having issues with the time calculation.

Let say in cell "A1", I have 12.59. I recognize this as the noon time 12.59. Now I want to subtruct this time with 10h30m, i.e. the resulting number should be 2.29AM.

Is there any direct Excel function to do that?

Thanks for your input.

BrianMH
12-24-2012, 02:45 AM
Well you can enter 12:59 in a cell and then 10:30 in another cell and then just subtract the cells.

arrun
12-24-2012, 03:29 AM
Hello BrianMH, thanks for your input. However your suggestion should not work because, it is time-calculation not really decimal calculation.

Any better idea?

Thanks and regards,

BrianMH
12-24-2012, 04:49 AM
Ok so you are entering it as a decimal but thinking of it as a time and you want excel to treat it as a time?

Assuming that there are always 2 digit hours and seconds and the time is in cell a1 the below formula would work.

=TIME(LEFT(A1,2),RIGHT(A1,2),0)-TIME(10,30,0)