Z
Zsolt Szabó
How do I convert more than 24 hours time to decimal?
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.
S
Sandy Mann
Custom Format the cell as [h]:mm the square brackets will stop the hours
rollong over into days when they get to 24 hours.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
rollong over into days when they get to 24 hours.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
D
David Biddulph
But that's not in decimal.. To convert from Excel time format to decimal
hours, multiply by 24 and format as number or general.
--
David Biddulph
hours, multiply by 24 and format as number or general.
--
David Biddulph
Sandy Mann said:Custom Format the cell as [h]:mm the square brackets will stop the hours
rollong over into days when they get to 24 hours.
S
Sandy Mann
Oh yes! I forgot about that bit <g>
Time for bed I think.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
Time for bed I think.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
David Biddulph said:But that's not in decimal.. To convert from Excel time format to decimal
hours, multiply by 24 and format as number or general.
--
David Biddulph
Sandy Mann said:Custom Format the cell as [h]:mm the square brackets will stop the hours
rollong over into days when they get to 24 hours.