Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
Can I convert numeric 0510 to time 05:10 by custom cell format? | Excel Discussion (Misc queries) | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
In Excel how can you convert a cell formatted for time (4:30) to . | Excel Worksheet Functions | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) |