Thread: Time difference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephanie
 
Posts: n/a
Default Time difference

This is time worksheet:

Time in/time out/Number hours/difference.

First three are fine. The difference should be the difference between
column C and 8 hours.

Ideally, it would show the difference in hours and minutes. I've tried
=C2-8, but all I get is #######.

Any suggestions?

--
Steph