MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Changing number to mins/seconds

• Follow

```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.
```
 0

```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.
```
 0

```What about this:
=TIME(,,A1)

Format as:
mm:ss

HTH,
Ryan---
--
Ryan---

"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.
```
 0

```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.
```
 0

3 Replies
468 Views

Similiar Articles:

7/22/2012 5:38:03 AM