Calculating Dates and Hours

  • Thread starter Thread starter tom_coekaerts
  • Start date Start date
T

tom_coekaerts

Hi there,

I'm trying to calculation days and hours. For example

cell A1 22.12.03 09:00 AM
cell B1 24.12.03 04.00 PM
cell C1 the result for example 2 days and 14 hours or an
other format.

Can anybody help me???

Regards,

Tom
 
Hi
one way:
- Enter the formula: =B1-A1
- format Ce with the custome format [hh]:mm
and you get the total hours

Another way:
- enter the formula: =INT(B1-A1)-(B1<A1) & " days and " &
(B1-A1)-INT(B1-A1)+(B1<A1) & " hours"
Though this output can't be used directly in other calculations
 
Back
Top