Excel Time

  Belfix 21:07 10 May 2005
Locked

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 2005

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

click here

  TOPCAT® 22:32 10 May 2005

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

click here

  Belfix 15:36 12 May 2005

Thanks TopCat - all solved!!

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

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?