Search results

Mihal and ypma: thank you both for offering up your help. Mihal: I tried your suggestion and it does not produce the result in decimal format. By decimal format I do not mean put a decimal point in between the hour and minutes but the act of converting time such that 30 minutes divided by 60...

Found something in another post with a reply by Galaxiom but since I am new member I can't link the url. Thanks Galaxiom. =Round(([PunchOut]-[PunchIn])*24,(2)) This will give me a two decimal point version of decimal time but if the result is 5.80, you will only see 5.8 I was hoping to have...

Looking for help on a formatting issue regarding elapsed time calculated using DateDiff(). I understand that you can specify the output value for DateDiff(). In my case I have chosen "n" for minutes. Each result in my query shows the correct calculation in terms of minutes. [PunchIn] =...

Thanks Paul (pbaldy) for pointing me in the right direction. After a little trial and error I arrived at the following expression: OtherPay: IIf(Weekday([PunchOut])=1 Or Weekday([PunchOut])=7,IIf(TimeValue([PunchOut])>=#12:00:00 AM# And TimeValue([PunchOut])<=#6:00:00...

Greeting everyone. This is my first post. I have a working dB which can calculate a shift duration and sum total all shifts worked within a period for the purpose of producing a labor report for payroll. I have successfully used the DateDiff function and converted the minutes to HH:MM on my...

Greetings everyone! I have always been interested in learning about database design and development but I never imagined that I would enjoy it as much as I do. I am mostly self taught but have taken one college level course for database design. I continue to build projects to solve work...