excel 2003 formatted time 12:00 AM shows as 12:00:00 am

S

sctlippert

New Member
Joined
Apr 9, 2011
Messages
12
I am inputting hourly times worked on a schedule. I have formatted the cells in excel 2003 in the time format "1:30 pm". If a person works from 12:00 am to 07:00 am, when 12:00 am is entered in a cell, it looks blank, but if you click on the cell the value is 12:00:00 am. I've tried to reformat it multiple times. What am I missing? When the formula is used involving that cell, the value of 12:00 am is being utilized correctly, it just won't display the time format in the cell, it remains visibly blank!!!
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
I figured out my own question. I have the worksheet set not to show "0" values. Since 12:00 am will equal "0", that is what happened.

Go figure.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
TIME LIMITATIONS
Replies
1
Views
85
cooleomter
C
M
  • Locked
  • Question Question
Trying to input time calculation so it does not change to 24 hour format
Replies
3
Views
161
Peter_SSs
Peter_SSs
T
  • Question Question
How to change raw time data from 07:05:00 to 07:05:00 AM? Not able by format
Replies
2
Views
272
teodora bocarski
T
C
  • Question Question
Deducting hours to show time less than 00:00
Replies
3
Views
291
rollis13
rollis13
M
  • Solved
sumifs using date and time values
Replies
9
Views
358
Asbestos_Jen
Asbestos_Jen

Forum statistics

Threads
1,224,609
Messages
6,179,875
Members
452,949
Latest member
Dupuhini

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top