Hi


A1= 10:15
B1= 12:15
C1 = 3

formula in another cell
=((B1-A1)*24)*C1
Format as general

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.