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