Date/Time entry difference formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
-----Original Message-----
Excel 2000 formula for finding the difference between 2
Click to expand...
dates(1/1/04) & 2 times(1300(military))in hrs (hhhh.h).
Example- The difference between 1/15/04 @ 1500 and
Click to expand...
1/20/04 @ 1330 would equal 4 days/22 hours/30 minutes
, or 118.5 hours.
.
Found simple formula for calculating number of days
Click to expand...
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
 
Back
Top