how do i find a true value between two different times e.g. 4:15

C

Chris01623

i would like to find the exact value between two different time in hours and
minutes e.g. 4:15 (4 hours 15 minutes) and not 4:42 (4.42 hours) for example.
 
J

Jim Rech

Subtract them! An example: Enter 8:45 in A1 and 5:15 in A2. Enter the
formula =A1-A2 in A3 and, voila, the answer is 3:30. Excel will
automatically assign the time format to A3 if it has the General number
format.

--
Jim
|i would like to find the exact value between two different time in hours
and
| minutes e.g. 4:15 (4 hours 15 minutes) and not 4:42 (4.42 hours) for
example.
 
S

Stefi

Hi Chris,

A1 = 4:15
A2 = 4:42
A3 = A2-A1 = 0:27

If you enter these values Excel will automatically format cells as h:mm,
otherwise format yourself.


„Chris01623†ezt írta:
i would like to find the exact value between two different time in hours and
minutes e.g. 4:15 (4 hours 15 minutes) and not 4:42 (4.42 hours) for example.
Click to expand...

What is this "not" 4:42?

Regards,
Stefi
 
Top