Time calculation with Excel

[arrun]

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]

Well you can enter 12:59 in a cell and then 10:30 in another cell and then just subtract the cells.

[arrun]

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]

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)