Convert time in cell
 

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

Convert time in cell
 

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

=MINUTE(A1)+SECOND(A1)/60
--
HTH...

Jim Thomlinson


"John" wrote:

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

Convert time in cell
 

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


"John" wrote in message ...
|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