Thread: work hours with different hour prices
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default work hours with different hour prices
Hi,

Am Wed, 29 Jan 2014 05:44:31 -0800 (PST) schrieb
:

For example, with IN = 3:00 and OUT = 14:00 the results on C2 are 0.291667 and i would expect it to be 7 (14-7)

the result is correct. You have to format the cell hh:mm or h:mm


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote