convert a summed time value to hours only

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
How do I calculate time in excel (clock in and clock out 3
I have 3053 minutes and I want to convert to hours and minutes 2

Back
Top