I get 0:00 when I format cells 4 time no matter what # I enter
Ok, that was what I was wondering. I will have to enter the colon. Thanks
so much for your help.
"Niek Otten" wrote:
Try entering =NOW() and see what you get
If you want to enter times manually, enter 7:20 for example, not just a
number
The number will be interpreted as a date, 0:00h
You can check that in the formula bar
--
Kind regards,
Niek Otten
"Mardy" wrote in message
...
|