G Guest Apr 22, 2006 #1 How do I change Hrs and mins in a cell in one work sheet to autoformat into minutes in a cell in another worksheet?
How do I change Hrs and mins in a cell in one work sheet to autoformat into minutes in a cell in another worksheet?
N Niek Otten Apr 22, 2006 #2 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?
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?
B Bob Phillips Apr 23, 2006 #5 What does your original data look like? -- 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? Click to expand... Click to expand...
What does your original data look like? -- 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? Click to expand... Click to expand...
