Absolute Time

[bajjo]

a2 = 03/03/2003 20:52:17
b2 = 13/04/2003 21:22:06

I am calculating difference between two date/Time Value and then their
Absolute Value using these formula.

Cycle time = b2-a2

Cycle time(Result) = 984:29:49


Absolute cycle time =
DAY(B2-A2)*24+HOUR(B2-A2)+MINUTE(B2-A2)/60+SECOND(B2-A2)/3600

Absolute cycle time(Result) = 302.497

Where the result of Absolute Cycle time is wrong. That's because DAY()
returns a value between 1 and 31 - which gives
a maximum of 744 hours (+ 24 for the HOURS() comparison).


How to solve above problem so that i can get right result.(i.e Absolute
Cycle time).

Thanks!!

 

[Harald Staff]

Hi

Assuming you by Absolute mean decimal number; you can either use INT instead of DAY, or
use the far simpler formula
=(B2-A2)*24
you may have to manually format the result cell as decimal number after entering this.

HTH. Best wishes Harald
Followup to newsgroup only please.

 

[J.E. McGimpsey]

If I undersatand you correctly, it looks like you can calculate what
you're calling "Absolute cycle time" as

=(B2-A2)*24 ===> 984.496944444487