formula to turn hh:mm cell into x.y hours

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I need to track billing for a client, with 1/10th hour precision, and where
partial groups of 6 minutes round up to the next 1/10th hour (example: 8
minutes = 0.2 hours). I have a start time, and an end time. Then I
subtract one from the other and get hh:mm, such as 1:08 which represents 1
hour and 8 minutes. So far so good. But then I want a formula that
converts that to 1.2 hours. But everything I try is failing. I can't
even figure out how to convert the 1:08 to 68 minutes. Please help me with
the formula for the cell below:

Start Stop Duration BillableHours
8:00 9:08 1:08 ?????

????? should show 1.2

Thank you.


.

Relevant Pages

  • Re: formula to turn hh:mm cell into x.y hours
    ... Microsoft MVP - Excel ...
    (microsoft.public.excel)
  • Re: making test(1)s -nt/-ot ignore nanosecond fractions
    ... Changing it to microseconds precision is safer, ... foo 1084087769.000000000 ... foo has a normal mtime set by writing on the server ... should run on the client and set the times to ...
    (freebsd-current)
  • Re: [PHP] Pre-printed forms
    ... From my old days working with a vertical-mill, precision means to produce the same product repeatedly within tolerance, while accuracy means to hit the mark. ... If I had a client who wanted me to produce a document that would match his specifications accurately, then I would create PDF documents. ... DPF documents can be created and printed with accuracy across different platforms. ...
    (php.general)
  • Building a bass (another link)
    ... I've posted here before about the restoring work done by Bravewood Guitars. ... the guy who runs the business is building a Precision for a client and is posting the progress on this link. ...
    (alt.guitar.bass)