View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John_mitch
 
Posts: n/a
Default How do I use Excel with times which are negatives?

e.g.

I work 35 hours a week, 7 x 5 days. Any time over 7h per day is flex time.
Any less than 7 is negative flex time. I need to calculate daily my running
flex time. Flex time needs to be both positive and negative and displayed in
hh,mm. My cycle runs 4 weekly.

Ta!