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

Nokia 8 vs Galaxy S8

Best new design books 2017: From vintage infographics to the the psychology of type

iMac 21.5-inch (2017) review

Nokia 8 : design, caractéristiques techniques, date de sortie