Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing number to mins/seconds
I want to change data that is just a normal number into mins and seconds.
e.g. 80 --- 1:20 or 1.20 or something, so it is recognisable as 1 minute 20 seconds Katie. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing number to mins/seconds
What about this:
=TIME(,,A1) Format as: mm:ss HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Katie" wrote: I want to change data that is just a normal number into mins and seconds. e.g. 80 --- 1:20 or 1.20 or something, so it is recognisable as 1 minute 20 seconds Katie. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing number to mins/seconds
Thank you!
Next question: if i had a column of data and i need to group/subtotal any cells containing zeros or isolated zeros, wat formula do i put in eg. 0 ) 1 ) 0 ) 0 ) subtotal = 4 (so i know it was a group of four cells) 4 5 1 6 5 0 ) 1 ) 0 ) subtotal = 3 6 7 8 0 ) subtotal = 1 basically the data shows steps and rests, and we need to know how long the rest periods are. single steps surrounded by rest (0) need to be counted as rest intervals. if that makes sense... Katie. "Mike H" wrote: Katie, Try this =A1/(24*60*60) Format as hh:mm:ss Mike "Katie" wrote: I want to change data that is just a normal number into mins and seconds. e.g. 80 --- 1:20 or 1.20 or something, so it is recognisable as 1 minute 20 seconds Katie. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing number to mins/seconds | Excel Worksheet Functions | |||
how can i convert a value quoted in hrs,mins,secs to just mins | Excel Worksheet Functions | |||
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
Convert mins:secs to seconds only | Excel Worksheet Functions | |||
How to convert numeric value to mins and addimg mins to Hrs. | Excel Worksheet Functions |