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.
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.