can if then else be used in a formula

[cfinch100]

hi
can you use if then else in a formula like
if a1 07:00hrs is less than f1 08:00hrs then difference is1
what im trying to do is our working day is 08:00 to 16:30, 0700=0800 is o/t1.5 but 00:00 to 07:00 is o/t2,else 08:00 to 16:30 is single ,so if I go to work at 06:00 I would have 1 at x2 and 1 atx1.5, and 8 hrs at normal time,how could this look in a formula have tried a few today but getting tied up in knots
cheers colin

[etaf]

if then else - you can use

if, test , true , false
which you can do a

if , test , true, if , test, true , false

=IF( A1 < F1 , 1


if your start hour is in A1,

=IF(A1<=TIME(8,0,0), 1,0) that will test if the start time was before 8:00

=IF(A1<=TIME(8,0,0), HOUR(TIME(8,0,0)-A1),0)
will calculate how many hours are before 8:00

so you could now multiply that by the 1.5 rate

[millz]

I messed around a little, don't know if this helps.

[Winon]

Hello cfinch100,

I find your post quite confusing. Why don't you upload a sample Workbook of the layout and the expected outcome. We may then be in a better position to reply with a ready solution.

Regards

[cfinch100]

hi etaf
that was exactly what I wanted to do ,can now try and expand it to after 16:30 now
many thanks cheers colin

[cfinch100]

hi millz
yes that helps lots as well ,should be able to sort from here for a while
many thanks colin

[cfinch100]

hi millz
have been playing with this most of day and stuck again, all works till 16:30, from 16:30 till 20:00 its 1.5 and then x2 to midnight where yours takes over have tried changing 1/24* to various settings just not sure how this was set up any chance of few pointers please
cheers colin

[millz]

Maybe post what you have so far? I don't know how you determine when did the working hours stop counting, another cell with Time end?

[cfinch100]

hi millz
this is what I have row 9 does mon to thurs from 0000 to 1630 ,0000 to 0600 is rate x2 ,0700 to 0800 is x1.5 and 8 hrs to 1630,having trouble using formula fro 1630 to 1900 rate x1.5 then 1900 t0 2400 rate x2,have tried various ones just getting in a muddle now ,was going to use separate one row26 for second part of day ,how can you tell exc el what time you want it to start from ,or am I going wrong way about it
cheers colin

[millz]

Hi cfinch100, sorry about the late reply, I looked but didn't have time to post something and then forgotten about it.

I don't know if you have already come up with a solution, but it seems like this is getting more complicated. You probably will need to subtract using both date and time.

You would need a start date+time, and an end date+time to effectively calculate it.