convert decimal to hours and minutes

S

sallyt

Help! Is there a way of doing this please: I want to
multiply number of hours a person has worked (eg 35)
x .385 (which is the number we have calculated that works
out holiday entitlement on a weekly accrual basis) then
divide that by 4, eg =(35*.385)/4 I then want to take
that result and display not in decimal figures but in
total hours and minutes. Have tried =TEXT divided by
24, as per help, but this doesn't seem to do what I want.
Any clues please? Thanks. Sall
 
N

Norman Harker

Hi Sall!

Try:
=((A1*0.385)/4)/24
Format hh:mm

For your example of A1 is 35 it returns 3:22

We divide by 24 to convert ti Excel Date / Time serial number where
time is a decimal portion of 1 day. If you are totalling results and
the total can exceed 35, then format the total [hh]:mm
 

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
Convert decimal days to hours and minutes 2
Convert 29.08 hours (shown in decimal form) to time shown in "hh:m 1
Hours and sum of hours 2
Converting a decimal time into hours and minutes 1
how do i convert a column of minutes into hours 2
Convert Decimal hours and Minutes to minutes please. 13
sum hours minutes seconds excel 2003 1

Top