Change hrs&minutes into mins
 

How do I change Hrs and mins in a cell in one work sheet to autoformat into
minutes in a cell in another worksheet?

Change hrs&minutes into mins
 

Format Custom as [mm]
If you require a number of minutes to calculate with: =A1*24*60 (time is stored as a fraction of a day)

--
Kind regards,

Niek Otten

"Indie" wrote in message ...
| How do I change Hrs and mins in a cell in one work sheet to autoformat into
| minutes in a cell in another worksheet?

Change hrs&minutes into mins
 

Cheers for your reply, but it still comes up with 00000's

"Indie" wrote:

How do I change Hrs and mins in a cell in one work sheet to autoformat into
minutes in a cell in another worksheet?

Change hrs&minutes into mins
 

Cheers for the reply but I ended up with a figure of 0000

"Niek Otten" wrote:

Format Custom as [mm]
If you require a number of minutes to calculate with: =A1*24*60 (time is stored as a fraction of a day)

--
Kind regards,

Niek Otten

"Indie" wrote in message ...
| How do I change Hrs and mins in a cell in one work sheet to autoformat into
| minutes in a cell in another worksheet?

Change hrs&minutes into mins
 

What does your original data look like?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Indie" wrote in message
...
Cheers for the reply but I ended up with a figure of 0000

"Niek Otten" wrote:

Format Custom as [mm]
If you require a number of minutes to calculate with: =A1*24*60 (time is
stored as a fraction of a day)

--
Kind regards,

Niek Otten

"Indie" wrote in message
...
| How do I change Hrs and mins in a cell in one work sheet to autoformat
into
| minutes in a cell in another worksheet?