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

"AlanStotty" wrote in message
oups.com...
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.