Formatting a cell?
 

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

Formatting a cell?
 

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

Formatting a cell?
 

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

Formatting a cell?
 

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

Formatting a cell?
 

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

Formatting a cell?
 

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

Formatting a cell?
 

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

Formatting a cell?
 

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