Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Decimal Subtractraction
Hello from Steved
7.58 from 8.15 is 17 minutes 12.55 from 1.15 is 20 minutes Could I please have a formula for the above please. Thankyou. |
#2
|
|||
|
|||
Will 1.15 *always* be 1:15 PM? Will 8:15 always be 17 minutes after
7.58, or might it sometimes by 737 minutes? In article , Steved wrote: Hello from Steved 7.58 from 8.15 is 17 minutes 12.55 from 1.15 is 20 minutes Could I please have a formula for the above please. Thankyou. |
#3
|
|||
|
|||
presuming you enter 1:15 as 1:15 pm, simply subtract the first from the second and format as time. If you want the result as an integer 17, then multiply the above result with 1440 which is nothing but 24*60 Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=379586 |
#4
|
|||
|
|||
Steved
Assume that the first time (i.e. 7:58 and 12:55) is is A1,A2 and the end times are in B1, B2. Firstly format the columns to be TIME and in a 24 hour clock format. Then in C1 enter =b1-a1. Then either copy the formula down as far as you want or use the FILL handle to copy down. HTH Pank "Steved" wrote: Hello from Steved 7.58 from 8.15 is 17 minutes 12.55 from 1.15 is 20 minutes Could I please have a formula for the above please. Thankyou. |
#5
|
|||
|
|||
Thankyou
"Pank" wrote: Steved Assume that the first time (i.e. 7:58 and 12:55) is is A1,A2 and the end times are in B1, B2. Firstly format the columns to be TIME and in a 24 hour clock format. Then in C1 enter =b1-a1. Then either copy the formula down as far as you want or use the FILL handle to copy down. HTH Pank "Steved" wrote: Hello from Steved 7.58 from 8.15 is 17 minutes 12.55 from 1.15 is 20 minutes Could I please have a formula for the above please. Thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Dots into Commas as Decimal Divider | Excel Discussion (Misc queries) | |||
I need help insert a decimal other then directly to the right of t | Excel Discussion (Misc queries) | |||
Changing default decimal places | Excel Discussion (Misc queries) | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
decimal point override does not work | Excel Discussion (Misc queries) |