Calculate Total Time Spent on a Job in Hours, Minutes with DateDiff in Microsoft Access, Time Clock

[@Jojosmith342]

Thtank you so much Richard for another valuable lesson. This helps me with the job. You make our lives so much easier. Thanks a lot for your hard work. Thumbs up even before starting. You love teaching people and we love learning from you. Can't sleep well without thumbs up to Richard's tutorial 👍

[@599CD]

You're too kind

[@ianjohnson2866]

Hi Richard, absolutely just what I was looking for and so clearly described, thank you so much!

[@599CD]

Welcome!

[@ehteshamshah]

Sir U solve my problem in this video, Hats off

[@599CD]

Thanks

[@jayd3578]

omg you read my mind. that was a question i was going to ask. thanks.

[@599CD]

You bet!

[@almarkbermudo9375]

I learned a lot. Thank you Rich.😎

[@599CD]

Welcome

[@dougpowell1827]

Richard, learned so much from you already! Do you have a video on Tree views in MS Access?

[@599CD]

Access Developer 20: 599cd.com/ACD20

[@AchaikiDiachiristiki]

Your video is very useful but I would like to ask what happens when the pay per hour is different whether it is day, night or Sunday. For example, if the job starts on 11/15/2020 18:00 and ends on 11/16/2020 03:00, how do we calculate how many hours will be paid with price per hour (a) and how many paid with price per hour (b) when (a) is between 06: 00 and 22:00 and (b) between 22:00 -06:00 ?

[@599CD]

That would involve some additional calculations. Feel free to submit it: 599cd.com/TechHelp

[@nursinta7503]

How do you calculate the total delay time of 60 minutes in a day?

[@599CD]

I don't understand your question please elaborate

[@SumanDevi-rx3jd]

Hi!Good video! Can you please guide me on what datatype to use for storing hours says 1500 h 45 min in an access table?

[@599CD]

Are you saying you want to display a normal time in that format?

[@SumanDevi-rx3jd]

@@599CD Yes. Is there a means for storing durations in access without resorting to text data type or the confusing number format?

[@considerthis9999]

Hi great tutorials , but TotalMinutes: DateDiff("n",[TimeIn],[TimeOut]) keeps kicking out "invalid syntax"

[@599CD]

Don't know what to tell you. It works for me. I've been teaching this for 27 years and it's been the same the whole time. Maybe you've got a problem somewhere else in your query. Try running down this: 599cd.com/Trouble

[@SuperChrispol]

try with ; instead of ,

[@surf68za]

Did you find an answer , I get the same thing ?

[@nurmohammed6355]

hi richard I need your help, in this video you add a formula. how can implement this formula in my database? that is table example, machine breakdown start time and breakdown end time, how can calculate? how many times was machine breakdown? i'm waiting for your answar. Thanks.

[@599CD]

599cd.com/ask

[@djkldkedie]

muchas gracias me ayudado mucho

[@SprintingMini]

Great instruction. How do you display 'SumOfFractHours' in your TimeClockQ as hours/mins?

[@599CD]

Feel free to submit your questions at 599cd.com/TH. Members get priority.

[@kellyfoley1575]

Where do I find the 40 min extended cut. I am a new silver member and can not find this vide?

[@599CD]

The link is right in the description of this video. Takes you here: kzbin.info/www/bejne/bqnNYaKudseNpqs

[@rouellmicoh.e.g5409]

Hi Sir, how did you create that kind of format on time in and time out? it is possible to have a time picker with date? Thank you in advance

[@599CD]

599cd.com/TimePicker

[@rouellmicoh.e.g5409]

@@599CD Thanks for the reply, link is unavailable

[@599CD]

Try again now

[@smitamirashi2014]

That I exactly want you are Great!

[@599CD]

Thanks!

[@hazemgad1243]

Please, how to calculate the electrical power consumed during the night shift , the first counter reading is at 8:00 pm and the second reading at 8:00 am the next day, Thanks

[@599CD]

Feel free to submit your question here: 599cd.com/TechHelp

[@edmonfortes4672]

How I can make a running total for the your displaytime column for example. Please help Sir it's the last thing I need for my project.

[@599CD]

599cd.com/a?24141

[@ulyssesvillagonzalo4959]

Hi, how can you prevent the date and time(s) from being changed when the employee(s) press the button(s) twice or more? is it possible that no matter how many times they press those buttons, the time won't change since it was pressed the first time, when he or she clocked in?

[@599CD]

Sure. That all depends on how you're clocking them in. If you're using a button, just put some code in the button that says if there is already a StartTime, don't let them save another StartTime. If you want to use a BeforeUpdate event to check the value, you can do it there too. There's a million ways to do everything in Access. I cover some options in my TimeClock video: 599cd.com/TimeClock

[@mariossher7710]

can i use this for employee tracking like vacations and stuff ?????? please if you could answer me im in a hurry

[@599CD]

Sure.

[@andreasnesheim9903]

Good tutorial. Though following all your steps, I end up with a "quadruple report", that meaning, when I run the query the result repeats it self. Even tho the Table only have 4 inputs. How or why do you think this happens? Possible solution?

[@599CD]

No idea. I'd need to see it.

[@CambodianTutorials]

thanks

[@599CD]

Welcome

[@aquariumfishes1584]

Good

[@599CD]

thx

[@soniagaied]

Thank you, but the problem still exists. It's not 15.75 hours, but rather 16.15 hours.

[@599CD]

Huh?

[@soniagaied]

@@599CD My previous understanding was incorrect, but thanks to your assistance, my problem has been resolved.