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
|