Module To Calculate Time Difference

B

Brent

I have a question that is way over my head. I trying to report out of a
database for a time and materials tracking software my company purchased.
I need to calculate the number of working hours between 2 dates and times
only they are stored in separate fields. Ex sdate, stime, edate, etime. To
make matters worse on my novice end the time is stored in decimal
format(example 1:30PM is stored as 12.50). Anyone got an idea for what
code could calculate the working hours difference in these times. Our
working hours are 8:00AM to 5:00PM.

Thanks
Brent
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hours Calculation 2
How to calculate difference between two date & time along with working hours and days 2
Calculate time difference 3
Difference between times. Start time: 11:30PM End time: 5 AM 5
calculate time to complete application 8
Difference of Time 1
Calculate Time in A Report 5
Difference between date & time calculation 6

Top