how come when i enter in a time of 24:00 in the format of: [h]:mm i am getting a value of: 1/1/1900 12:00:00 AM in the formula bar? and most importantly how can I fix this? I want just the 12:00:00 AM to show in the formula bar and 0:00 or 24:00 in the cell.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
time format headache!
- Thread starter plost33
- Start date
Similar threads
- Solved
