View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Dav
 
Posts: n/a
Default Need formula to calculate hours worked


I am not able to see your formula that does the calculation, but if the
result is contained in G16 an option is given below although the answer
is in decimal hours and is a text string so it depends what you wish to
do with it

=IF(G160,G16,(TEXT(G16*24,"0.00")))


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=501797