How do I display the h:mm minutes in hundreds?

G

Guest

My company uses a time clock that uses hundredths of an hour rather than
minutes. Is there a way to display the h:mm in hundreths rather than minutes
without having to convert the time to minutes first, so that I can use the
time functions in the graphing and charting?
 
P

Peo Sjoblom

Multiply with 24 and format as general, I.e. you have 2:30 in a cell but
want 2.5 instead

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

Daily Time Sheets with Rounding 1
convert length of time to minutes from hundreths 2
Converting Seconds to Hours, Minutes, Seconds 3
Is there a simple formula to convert time in hundredths to minute 10
Calculating Time from Speed and Distance? 3
Creating a chart to convert hundredths to minutes 2
How do I add times that were creted with "=TEXT(A2-A1,"h:mm")"? 3
Converting to h:mm from regular number 1

Top