Home & Garden0 min ago
Excel Time Format
25 Answers
I'm creating a time sheet for someone and have colums of time on site and time off site. I've tried to format the colums so that if he types 9 then it formats it to a time.
I highlighted the cells and seletect the 'time' format but every time I enter a number it just comes up as 00.00.00
When I remove the format the number I typed in appears.
I can't work out what I'm doing wrong?
I highlighted the cells and seletect the 'time' format but every time I enter a number it just comes up as 00.00.00
When I remove the format the number I typed in appears.
I can't work out what I'm doing wrong?
Answers
Best Answer
No best answer has yet been selected by EvianBaby. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.This is very weird, I tried that after your last response and a few others too but I still get the same result. I selected the hh:mm format.
If I enter 9.30 it very oddly shows the time of 07:12 in the cell. In the function bar at the top is shows - 09/01/1900 07:12:00
It's showing some sort of date but I've only selected a hh:mm format. Confused.
If I enter 9.30 it very oddly shows the time of 07:12 in the cell. In the function bar at the top is shows - 09/01/1900 07:12:00
It's showing some sort of date but I've only selected a hh:mm format. Confused.