Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find within Workbook. | Excel Discussion (Misc queries) | |||
How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
VB find (true false) | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |