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.

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.

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.

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.