Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas, question for Roger Govier
Roger I have been looking at your reply of January 9th to Dave about his
question about a formula for tool rental. I have been trying to get this formula to work, but I keep coming up with the answer 7920. In using military in the time out and time in, do these cells need to be format a special way? If so how do I do that, I think that may be what my problem is. Thanks in advance, Gordon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas, question for Roger Govier
I bet you are entering time as 1100 and 1430. Roger's formula assumes 11:00
and 14:30. To make yours work, try =(D1+TIME(INT(C1/100),MOD(C1,100),0))-(B1+TIME(INT(A1/100),MOD(A1,100),0)) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "BigBuck98" wrote in message ... Roger I have been looking at your reply of January 9th to Dave about his question about a formula for tool rental. I have been trying to get this formula to work, but I keep coming up with the answer 7920. In using military in the time out and time in, do these cells need to be format a special way? If so how do I do that, I think that may be what my problem is. Thanks in advance, Gordon |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas, question for Roger Govier
Thanks Bob, thats exactl what I was doing.
Gordon "Bob Phillips" wrote in message ... I bet you are entering time as 1100 and 1430. Roger's formula assumes 11:00 and 14:30. To make yours work, try =(D1+TIME(INT(C1/100),MOD(C1,100),0))-(B1+TIME(INT(A1/100),MOD(A1,100),0)) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "BigBuck98" wrote in message ... Roger I have been looking at your reply of January 9th to Dave about his question about a formula for tool rental. I have been trying to get this formula to work, but I keep coming up with the answer 7920. In using military in the time out and time in, do these cells need to be format a special way? If so how do I do that, I think that may be what my problem is. Thanks in advance, Gordon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question On Excel Formulas | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Tricky formulas needed | Excel Worksheet Functions |