G
Graham Savell
I want to operate a simple time shet that will convert time into a decimal
number i.e
Time started 5.15 pm [hours,
minutes]
Time finished 7.30 pm [hours,
minutes]
Elapsed time 2.15 [hours,
minutes]
Equals 2.25 hours
Is it also possible to make the formula work from morning to afternoon -
i.e. 11.15am to 1.30pm = 2 hours 15 minutes = 2.25 hours
Thanks in advance
number i.e
Time started 5.15 pm [hours,
minutes]
Time finished 7.30 pm [hours,
minutes]
Elapsed time 2.15 [hours,
minutes]
Equals 2.25 hours
Is it also possible to make the formula work from morning to afternoon -
i.e. 11.15am to 1.30pm = 2 hours 15 minutes = 2.25 hours
Thanks in advance