View Single Post
  #1   Report Post  
LISVET
 
Posts: n/a
Default Need help with formulas


undefined

I am trying to create a worksheet to calculate the worked hours daily.
It formulates it that I have managed to do that but approaches which
desire the result gives it in hours. When I turn to him the hours in
general numbers it changes to decimal. That is, if I have an employee
who enters to work 7AM and leaves lunch to the 12PM, it returns 12:30PM
and it leaves to the 5:30PM formulates it present says to me that the
total is 10:00 A.M.. How this total I turn it to 10 (hours)

Help, Thanks


--
LISVET
------------------------------------------------------------------------
LISVET's Profile: http://www.excelforum.com/member.php...o&userid=27146
View this thread: http://www.excelforum.com/showthread...hreadid=466608