Convert time in cell

[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?

 

[Guest]

Assuming your time is in cell A1 a formula like this should do...

=MINUTE(A1)+SECOND(A1)/60

 

[Niek Otten]

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