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