News2 mins 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.