View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default More time please...

Assuming all cells formatted as [hh]:mm

Tools|options|Calculation
Check 1904 date system

Mike

"Jock" wrote:

How can I get around this:
"Negative times or dates are displayed as ####"?
The calc is 20:18 - 23:45
Answer should b -3:27
tia
--
Traa Dy Liooar

Jock