Formatting a cell?

[Phil L]

I'm looking for a way to format a cell that will break down overtime hours
for estimating. For example if an employee works 7 consecutive days the value
equal 112 hours. I'd like to be able to insert the number of days and it will
issue the value.
Oh by the way I'm a newbie

 

[Luke M]

You'll need to use a second cell. Let's say you enter your days in cell A2.
In B2, type
=A2*16
Then go to Format - Cell, and choose a time display, if you prefer.

 

[Phil L]

Let me try to be a bit more clear. Let's say that cell a2 is the number of
days worked. I'd like to write a formula that would create a value in cell
a4. The values are for 1 day =12 hrs, 2 days = 24 hrs, 3 days =36 hrs, 4 days
=52 hrs, 5days =70 hrs, 6 days = 88 hrs and 7 days = 112 hrs. Based on this
criteria can the values be looped in order to find the value for 14 or 20
days?

 

[David Biddulph]

Well the starting point is for you to define the rules that you are trying
to implement.
If the rule is that 1 day is equivalent to 16 hours, put the number of days
in A2, and use the formula =A2*16 to get the number of hours.

One thing for you to be aware of is that formatting a cell doesn't change
the value of the number in it, only how it is displayed.

 

[Luke M]

Is there some logic behind your values? Why do some days increment by 12
hours, some by 16, some by 18, and some by 24? If not, you'd have to create a
table, and have XL do some sort of LOOKUP or VLOOKUP.

 

[Phil L]

The reason of the different increments is they are results of hours worked.
Overtime begins after 40 hrs so the values are related to straight time. Iie;
is a man works 6 days @ 12 hrs/day it equates to 72 hrs which is broken down
as 40 hrs straight time and 32 hrs at time and a halh which equals 88 hrs of
straight time.

 

[Luke M]

then perhaps this will work for you
=IF(12*A2<40,12*A2,40+(A2*12-40)*1.5)

 

[Phil L]

Great job, it works, although I'll need to do a little tweaking.
Thanks a bunch