View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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