# formula recognising time

July 21, 2010 at 19:09:30
Specs: Windows XP
 How do I get a formula to recognise time eg. a payroll. Start: 06:00Finish: 09:00before 7am is paid at \$ 19 p/h and after 7am is paid at \$19.25 p/h.I want to be able to type in the hours then in a different cell the hours for before 7 automatically goes in it and the cell below the hours after 7 goes in it.Please help!

See More: formula recognising time

#1
July 22, 2010 at 06:53:21
 Hi,Try this:Format cells A1 and B1 as hh:mmEnter 06:00 in A1Enter 09:00 in B1Format the four cells A2 to B3 as numbers with two decimal places.Enter the pre-07:00 payrate in A2 (19.00)Enter the post-07:00 payrate in A3 (19.25)In cell B2 enter this formula:=24*(TIME(7,0,0)-A1)*A2In cell B3 enter this formula:=24*(B1-TIME(7,0,0))*A3This is what I got:``` A B 1 06:00 09:00 2 19.00 19.00 3 19.25 38.50 ```B2 shows the total pay before 07:00and B3 shows the total pay after 07:00Regards

Report •

#2
July 22, 2010 at 17:34:09
 Thankyou! That works =) But I am trying to get the hours automatically transferred to a pay slip eg.In the calendar you type the hours: 1 2 3 A Mon Tues WedB Start 6:00 6:00 C Finish 9:00 10:00D TOTAL 3.00 4.00Total hours(D2) =((C2-B2+(C2

Report •

#3
July 22, 2010 at 20:50:35
 Hi,To help sort this out you need to post actual data with correct row and column data.In your post you have row and column labels reversed.Also your formula:=((C2-B2+(C2

Report •

Related Solutions

#4
July 25, 2010 at 16:33:38
 Its ok, I have figured it out =) thanks anyway!

Report •