G
Guest
How do I change Hrs and mins in a cell in one work sheet to autoformat into
minutes in a cell in another worksheet?
minutes in a cell in another worksheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
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
| How do I change Hrs and mins in a cell in one work sheet to autoformat into
| minutes in a cell in another worksheet?
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
| How do I change Hrs and mins in a cell in one work sheet to autoformat into
| minutes in a cell in another worksheet?
G
Guest
Cheers for your reply, but it still comes up with 00000's
G
Guest
Cheers for the reply but I ended up with a figure of 0000
B
Bob Phillips
What does your original data look like?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
Indie said:Cheers for the reply but I ended up with a figure of 0000
Niek Otten said: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
| How do I change Hrs and mins in a cell in one work sheet to autoformat into
| minutes in a cell in another worksheet?