Date,Time Problem

  • Thread starter Thread starter bajjo
  • Start date Start date
B

bajjo

HI!!

We take the difference of two Date/Time Fields having Custom format and
Values like this

Start Date End Date Cycle
Time

2/24/03 16:30 3/25/03 10:11 689:41:41

m/d/yy h:mm m/d/yy h:mm [h]:mm:ss


Now I want this Time to be taken as absolute Number expressing it as
Hours/Minutes, so that I can take such values for further analysis.
But as such it is not possible because Excel always show “Cycle time”
value (689:41:41) as “28/01/1900 17:41:41”, and does not yield to any
arithmetic operations.
How I can use 689 Hours as a absolute value of time only, so that I can
do any arithmetic operations on it.

Thanks
 
Hi

1 is a day in Excel, so 1 hour is 1/24. Multiply 689 hours by 24 to get the
"real number" 689.
 
You could use a formula to determine the number of hours this represents.
Assume this data is in cells A2 and B2. Determine your cycle time with this
formula:

=DAY(B2-A2)*24+HOUR(B2-A2)

Now format this cell as General (Format, Cells, in the Number tab, select
General).

MRO
 
Back
Top