Search results

Thanks Colin, but my formula works for what I need it to do, I just need to have it return a blank value when no data is input in any of the data fields, or only partially filled. David

The ideal result would be blank space. As it is, when I run a report, with the "#Error" in that place it tells me "Data type mismatch in criteria expression", so a blank would enable to let me run my reports without having to fill in the data. David

Hey Mark, I Don't know if you remember me, but you helped me with this equation; Man/Hrs: Round(Nz(TimeDurationAsDate([Start Time],[End Time])*[Staff]*24,0),4) But the one thing is if all the fields are not filled in it returns a value of "#Error" and I cannot run any reports. I am using the...

Thanks Mark!, that did the trick. Thank you for being patient and explaining exactly in, layman terms, what you need from me to help. David

Ok, in the first screen shot, you enter the event details, then click on the event task tab, which is the second screen shot. You fill in each line for the task assigned, when you get to the column "Start Time", you enter the time the employee "Clocked In", the next column is "End Time", which...

Re: Hi and welcome to the forum. I see where you added "code tags", but it is still doing the same thing, If I put in "11:00 pm" to "12:00 am" the result is 0.999999999. What am I doing wrong?

Here it is; ' basDateTimeStuff Option Compare Database Option Explicit Public Function WeekStart(intStartDay As Integer, Optional varDate As Variant) ' Returns 'week starting' date for any date ' Arguments: ' 1. intStartDay - weekday on which week starts, 1-7 (Sun - Sat) '...

The Code they were referring to, I found in my modules. It is listed above your reply.

Oh, ok. I see what you are saying now, I did not realize he had made a module and dumped it in to my database, my apologies, here it is; ' basDateTimeStuff Option Compare Database Option Explicit Public Function WeekStart(intStartDay As Integer, Optional varDate As Variant) ' Returns...

That is the code, another user from another site gave that to me, told me to just drop it in the query, and it worked, except it gives me that funky number for anything less than an hour.

In my query this is the first; Man/Hrs: Nz(TimeDurationAsDate([Start Time],[End Time])*[Staff]*24,"") My second is; Man/Hrs Formatted: TimeElapsed(Nz(TimeDurationAsDate([Start Time],[End Time])*[Staff],0),"")

This is the functions, they are highlighted black with white lettering; And this one when ran shows the result, also highlighted.

And this goes into my query?, I don't see how it fits into the cell.

In my query this is the first; Man/Hrs: Nz(TimeDurationAsDate([Start Time],[End Time])*[Staff]*24,"") My second is; Man/Hrs Formatted: TimeElapsed(Nz(TimeDurationAsDate([Start Time],[End Time])*[Staff],0),"")

This was given to me by another person in this forum, it works great, except when calculating Start Time, for example, I put in 05:00 pm and End Time is 05:40 pm it will show 4.66666666666667 instead of 0:40:00. It only does this when 1 hour or less. I don't care if it shows 4.66, but all the...

I am having a problem with my calculation in my query. this is how it reads to give me my answer I need; Man/Hrs: Nz(TimeDurationAsDate([Start Time],[End Time])*[Staff]*24,"") but if it is one hour or less it will return a value of this; "0.999999999999999" If I use this calculation; Man/Hrs...