convert a summed time value to hours only

G

Guest

Would like to convert the sum total of time values to hours only.

Example is 286:30:00 convert to 286.5 hours
 
B

Bob Phillips

Multiply by 24 as time is stored as a fraction of 1 day

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 

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

Access Convert a decimal time to hours and minutes 2
How many are at work every hour in a 24-hour day? 2
CONVERT HOURS AND MINUTES TO INT 3
Quarter Hour time conversions for timesheet 2
Convert time to Half Hour inverval 3
Summing hours and munites 2
I have 3053 minutes and I want to convert to hours and minutes 2
How can I calculate hours into pay...in this format hh:mm:ss 2

Top