Convert time in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for help in how to convert the following:
16:06 (16 minuts and 6 seconds) to minutes (16.1 minutes)

Cell currently reads 16:06
How do I change so cell reads 16.1?
 
Assuming your time is in cell A1 a formula like this should do...

=MINUTE(A1)+SECOND(A1)/60
 
Hi John,

Make sure these are minutes and seconds, not hours and minutes

If OK:

=A1*24*60 and format as General

if not OK: check your Time format, it probably is Hours:minutes, not Minutes:seconds

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I am looking for help in how to convert the following:
| 16:06 (16 minuts and 6 seconds) to minutes (16.1 minutes)
|
| Cell currently reads 16:06
| How do I change so cell reads 16.1?
| --
| John
 
Back
Top