View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default I get 0:00 when I format cells 4 time no matter what # I enter

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