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

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Turn a photo into 16-bit pixel art

iMac Pro release date, UK price & specs

Comment suivre le parcours du père Noël ?