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

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.

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
"Chris01623" wrote in message
...
|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.

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.

What is this "not" 4:42?

Regards,
Stefi