Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 130
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 130
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing number to mins/seconds Mike H Excel Worksheet Functions 0 December 9th 09 11:31 PM
how can i convert a value quoted in hrs,mins,secs to just mins The man from delmonte Excel Worksheet Functions 1 October 17th 06 11:12 AM
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? StargateFan Excel Discussion (Misc queries) 8 January 7th 06 08:35 PM
Convert mins:secs to seconds only ronedwards Excel Worksheet Functions 3 November 4th 05 12:10 AM
How to convert numeric value to mins and addimg mins to Hrs. ramana Excel Worksheet Functions 1 October 28th 05 10:42 AM


All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"