Time Calculation

  • Thread starter Thread starter Robb
  • Start date Start date
R

Robb

How do you calculation time in a querry,,, example I have
a start time of 07:30 and a ending time of 16:30 how do
you calculation the difference? the answer i get is 0.375
 
The answer you are getting back is the decimal portion of the day. If you
multiply it by 24 you will see the actual difference in hours.
 

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

Time Calculated minus breaks & lunch 2
Time in calculated field for shifts going past midnight 0
Calculated field 5
Excel Functions 2
Datediff 2
Time calculation 2
EXCEL problem- mortgage 0
calculating running totals 2

Back
Top