software

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

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

quot;Indiequot; gt; 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?
Cheers for your reply, but it still comes up with 00000's

quot;Indiequot; wrote:

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

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

quot;Niek Ottenquot; wrote:

gt; Format Custom as [mm]
gt; If you require a number of minutes to calculate with: =A1*24*60 (time is stored as a fraction of a day)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Indiequot; gt; wrote in message ...
gt; | How do I change Hrs and mins in a cell in one work sheet to autoformat into
gt; | minutes in a cell in another worksheet?
gt;
gt;
gt;

What does your original data look like?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Indiequot; gt; wrote in message
...
gt; Cheers for the reply but I ended up with a figure of 0000
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt; gt; Format Custom as [mm]
gt; gt; If you require a number of minutes to calculate with: =A1*24*60 (time is
stored as a fraction of a day)
gt; gt;
gt; gt; --
gt; gt; Kind regards,
gt; gt;
gt; gt; Niek Otten
gt; gt;
gt; gt; quot;Indiequot; gt; wrote in message
...
gt; gt; | How do I change Hrs and mins in a cell in one work sheet to autoformat
into
gt; gt; | minutes in a cell in another worksheet?
gt; gt;
gt; gt;
gt; gt;