Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop time - start time calculation
This formula gives me a error message every time I enter something in the
worksheet: =D4-C4+IF(C4D4,1). It says Excel ran out of recourses and the formula could not be evaluated. Originally I was lookin for a formula that would calculate minutes of production time per shift. AM to PM and PM to AM. I am formatting my start and stop time as h:mm AM/PM and my result of the above formula as [m]. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop time - start time calculation
You didn't give a value for what to do if false. Thus, when you get a false
condition, its trying to add numbers to the word FALSE and messing up. You could try =D4-C4+IF(C4D4,1,0) -- Best Regards, Luke M "squack21" wrote: This formula gives me a error message every time I enter something in the worksheet: =D4-C4+IF(C4D4,1). It says Excel ran out of recourses and the formula could not be evaluated. Originally I was lookin for a formula that would calculate minutes of production time per shift. AM to PM and PM to AM. I am formatting my start and stop time as h:mm AM/PM and my result of the above formula as [m]. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop time - start time calculation
You don't need the IF function. You could use =D4-C4+(C4D4)
But I don't know why you're getting the report of resource problems with that particular formula. That error message is usually associated with large array formulae: http://support.microsoft.com/kb/166342. -- David Biddulph "squack21" wrote in message ... This formula gives me a error message every time I enter something in the worksheet: =D4-C4+IF(C4D4,1). It says Excel ran out of recourses and the formula could not be evaluated. Originally I was lookin for a formula that would calculate minutes of production time per shift. AM to PM and PM to AM. I am formatting my start and stop time as h:mm AM/PM and my result of the above formula as [m]. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop time - start time calculation
Don't know why you're getting that message but here's another way to write
that formula: =MOD(D4-C4,1) Or: =D4-C4+(C4D4) -- Biff Microsoft Excel MVP "squack21" wrote in message ... This formula gives me a error message every time I enter something in the worksheet: =D4-C4+IF(C4D4,1). It says Excel ran out of recourses and the formula could not be evaluated. Originally I was lookin for a formula that would calculate minutes of production time per shift. AM to PM and PM to AM. I am formatting my start and stop time as h:mm AM/PM and my result of the above formula as [m]. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop time - start time calculation
Are you sure, Luke? Have you checked?
The false condition will not return the *word* FALSE but the *boolean value* FALSE, and that will evaluate to zero (just as TRUE will evaluate to 1), which is why the IF function is unnecessary. [But it should not cause that error.] -- David Biddulph "Luke M" wrote in message ... You didn't give a value for what to do if false. Thus, when you get a false condition, its trying to add numbers to the word FALSE and messing up. You could try =D4-C4+IF(C4D4,1,0) -- Best Regards, Luke M "squack21" wrote: This formula gives me a error message every time I enter something in the worksheet: =D4-C4+IF(C4D4,1). It says Excel ran out of recourses and the formula could not be evaluated. Originally I was lookin for a formula that would calculate minutes of production time per shift. AM to PM and PM to AM. I am formatting my start and stop time as h:mm AM/PM and my result of the above formula as [m]. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stop time - start time calculation
I tried all of your suggestions and I still get the same error message. I
should state that I am using Microsoft Office Professional Plus 2007. I am wondering if displaying the time as military time would make a difference. If someone would like I could send you a copy of the spreadsheet I am working on to evaluate for yourself. Any and all help is appreciated. "squack21" wrote: This formula gives me a error message every time I enter something in the worksheet: =D4-C4+IF(C4D4,1). It says Excel ran out of recourses and the formula could not be evaluated. Originally I was lookin for a formula that would calculate minutes of production time per shift. AM to PM and PM to AM. I am formatting my start and stop time as h:mm AM/PM and my result of the above formula as [m]. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I stop the EULA message appearing every time I start Excel? | Excel Discussion (Misc queries) | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Formula for agenda to create start/stop with projected time of ev | Setting up and Configuration of Excel | |||
How can I get elapsed time between AM start/PM stop | Excel Worksheet Functions |