Time related to 24hr clock

**Stig** · 06-22-2009, 01:18 PM

Hi all,
I am a new user of this forum and this is my first post here

I have a problem concerning having the excel to operate with 24hr times.
What i try to achieve is:
from 00:00hrs to 24:00hrs = 24hrs which is 1.0 day
Have made the attached spredsheet to calculate it correctly to 1 day.
But if you look on the attachment the "total hrs" is saying 00:00 (it transfers to 00:00 when i am putting in 24:00)
Basically how am I able to make Excel to display 24:00 insted of 00:00

Maybe there is an add ins availible like the pop up calendar but for times instead.

Any help much appreciated.
Stig

**NBVC** · 06-22-2009, 01:23 PM

Welcome to the forum...

You can change the format of your cells..

Go to Format|Cells.. click Custom and put square brackets around the h...

e.g.

[h]:mm;@

**Stig** · 06-22-2009, 02:02 PM

Fantastic, here I got an answer within 2 minutes, and I have tried all possible and impossible attempts to solve this problem :-)
Actually I used £18.00 on just answer.com yesterday without succeeding, and wasted a lot of time.
Fantastic forum which already is marked as favourite :-)

**NBVC** · 06-22-2009, 02:13 PM

Sometimes... cheaper (free) is better!

Well, welcome to the forum, again and I hope you enjoy your stay.

**NBVC** · 06-22-2009, 02:16 PM

Please also remember to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save