If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
= versus > or < | an | General Discussion | 12 | August 18th, 2005 08:23 PM |
compile error | Walter | Using Forms | 4 | March 14th, 2005 08:56 AM |
check box on form | Erik | Using Forms | 4 | November 5th, 2004 02:39 PM |
Comparing Strings with < | Jonathan Rynd | Worksheet Functions | 3 | August 31st, 2004 06:54 PM |
decipher log of scanpst.exe | km | General Discussion | 0 | July 18th, 2004 09:00 AM |