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?