Excel Time

  Belfix 21:07 10 May 05

Have done this in the past - but can't remember how I solved it!!!!
Want to subtract one time value from another with the result possibly being negative. The time would be in hh:mm. Cant remember how to convert the #######'s and display the negative time. (Use is in automated overtime sheets when shift hours have been reduced)

  TOPCAT® 22:23 10 May 05

Scroll down page to the time features. Hope it helps you. TC.

click here

  TOPCAT® 22:32 10 May 05

"Change the starting date to January 2, 1904?" TC.

click here

  Belfix 15:36 12 May 05

Thanks TopCat - all solved!!

This thread is now locked and can not be replied to.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

1995-2015: How technology has changed the world in 20 years

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…