how do you change time(hours) into a number for multiplication e.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set up a spreadsheet to work out pay from hours worked
A B C D E
1 time time hours rate total
2 start fin worked per hr
3 9:00 17:30 8:30 £17 £144.50

How do I convert the hours worked (8½) into a figure that can be used in
formula E3=Sum(C3/D3)
 
=C3*24*D3

and make sure it is formatted as currency

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Probably an easier way than this but this is what I found:

in column A I have time (hh:mm) same in the next two columns. A is beginning
time, B is ending time, C is B-A. In D I put =hour(C1) then in E I put
=minute(C1). These two colomns now give you hours and minutes In another
column take the hours times the rate, and the same for the minutes column
..........that cell/60*rate, now sum these last two columns. I will be doing
this for my cataloging of my CD exported to excel to go from minutes and
seconds to aprox number of MBs per track. In help look at hour, minute and
time function. using hour minute and time as keywords. Hope this helps and
if anyone knows of any easier way pls share :O)
 
Oh god!!!!! that is soooo much easier. Where is my dunce cap? Maybe that is
why it takes me 3 hours to those 4 miles to home (j/k)
 
Back
Top