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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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

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?

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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

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.
--
David Biddulph

"Phil L" wrote in message
...
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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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?

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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

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" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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?

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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

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

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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?

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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

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

"Luke M" wrote:

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

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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?

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Phil L" wrote:

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