converting time

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
"Floyd Forbes" wrote
How do I convert 6:59 AM timein and 6:41 PM timeout to 11.70 decimal
Click to expand...
time?

Use the DateDiff function to subtract the timein value from the timeout
value and get the answer in seconds. Then divide that result by 3600, the
number of seconds in an hour, and you'll have the answer you want. Be sure
you do the final calculations using Floating Point variables, so you will
get the decimal fractional part.

Larry Linson
Microsoft Access MVP
 
Thanks

Larry Linson said:
"Floyd Forbes" wrote

time?

Use the DateDiff function to subtract the timein value from the timeout
value and get the answer in seconds. Then divide that result by 3600, the
number of seconds in an hour, and you'll have the answer you want. Be
sure you do the final calculations using Floating Point variables, so you
will get the decimal fractional part.

Larry Linson
Microsoft Access MVP
Click to expand...
 

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

Help with time. 2
total hours 2
Match, VLookup... who knows? 3
Converting Time Calculation to Decimal 5
Trying to return zeroes in between statement 5
Excel How To Convert Decimal To Inches 2
DatePart 1
Convert time to number 4

Back
Top