Date showing incorrect. 30:00 hrs showing 06:00

A

AlanStotty

Hi,

Can you help?????

When I insert 30:00 hrs it is showing as 06:00, when I check the cell
it actually showing as 01/01/1900 06:00. I have formatted the cell
to show hh:mm but still no luck.

Thanks in advance.
 
B

Bob Flanagan

Format it

[h]:mm

30-24 = 6, and it is showing as 6 o'clock for the next day in the default
time format.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
P

Pete_UK

You need to apply a custom format to the cell - [hh]:mm

The square brackets around the hh tells Excel not to wrap the hours
above 24.

Hope this helps.

Pete
 
B

bj

change you number format code to [h]:mm
hh will give the hours in one day (mod(total hours,24))
[h] will give total hours
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top