Date/Time entry difference formula

[Guest]

Excel 2000 formula for finding the difference between 2 dates(1/1/04) & 2 times(1300(military))in hrs (hhhh.h).

Example- The difference between 1/15/04 @ 1500 and 1/20/04 @ 1330 would equal 4 days/22 hours/30 minutes
, or 118.5 hours.

 

[John McGimpsey]

One way:

A1: 1/15/04 15:00
A2: 1/20/04 13:30
A3: =INT(A2-A1) & " days " & TEXT(MOD(A2-A1,1),"hh:mm")

to return 4 days, 22:30

or

A3: =A2-A1

format A3 with Format/Cells/Number/Custom [hh]:mm to return 118:30

or

A3: =(A2-A1)*24 ==> 118.5

 

[Brian]

-----Original Message-----
Excel 2000 formula for finding the difference between 2

dates(1/1/04) & 2 times(1300(military))in hrs (hhhh.h).

Example- The difference between 1/15/04 @ 1500 and

1/20/04 @ 1330 would equal 4 days/22 hours/30 minutes

, or 118.5 hours.
.
Found simple formula for calculating number of days

between two dates but had to install Analysis ToolPack
from the MS Office CD first. In cell where I wanted
results, I simply subtracted the end data from the start
date. Example: =C3-C1. But, you have to format the
result field as a number to get number of days. I
imagine the same might work if you have the dates
formatted to include hours - though not certain.

Might be worth a try - Good Luck, Brian