View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default how do I show the total of difference between two times in decima.

Sorry format the formula as Currency

Mike

"E. Lewis" wrote:

How do I show the total of difference between two times in decimals (numbers)
to calculate charges.

Example: time elapsed between 10.15 am to 12.15 pm = 2 hours.

Suppose a charge of $ 3/hr to be charged the total to be charged would 2*3 =
$6.

Excel does not give that answer if one enters that formula.

Will someone please help me with this question?

Thanks.