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.
|