microsoft excel training day courses near kent - Tea Timer

Dear Camil

I am not sure if you are asking a question relating to VBA or just a simple time calculation.

I would like a bit of more information to understand what is it that you want to achieve.

I am going to give you a general understanding of how Excel calculates time and also some things you have to keep in mind when you are performing such calculations.

When you insert a time for purpouse of calculation Excel converts it into a decimal no. So although for you 00:00:00 might be Midnight with 0 seconds but for Excel it is simply 0.0 and 23:59:59 is .999999.

All the times are between .0 and .999999.

How to Work with Time Formulas
How to Calculate Elapsed Time


Please refer to the Excel file that I have uploaded for the following explanation.

Cell A2 and B2 have time entered in them.
In Cell C2 and D2 the formula is exactly the same i.e. =B2-A2. You can see that C2 is displaying the result in Decimal format which is general Format from the Format > Cells