Solved subtract date and time less than 24 hours

March 31, 2014 at 11:36:58
Specs: Windows 7
i have two date with times 03/31 08:29 PM
& 03/31 07:29 PM
how to subtract them to obtain 1:00
without minus symbol thak you

See More: subtract date and time less than 24 hours

Report •

#1
March 31, 2014 at 12:12:14
✔ Best Answer
Just reverse the sum.

03/31 08:29 PM - 03/31 07:29 PM = 1

03/31 07:29 PM - 03/31 08:29 PM = -1

Int(03/31 07:29 PM - 03/31 08:29 PM) = 1

(03/31 07:29 PM - 03/31 08:29 PM) * -1 = 1

Stuart


Report •

#2
March 31, 2014 at 18:45:20
Are you trying to write script to do that or are you having a problem with the pencil-and-paper math of it all? If the former I think it's already been invented:

http://www.google.com/search?hl=en&...


Report •
Related Solutions


Ask Question