Times in Excel are stored as fractions of a day.
So 1 hour is 1/24th of a day.
Multiply your time difference by 24 and you get an integer/decimal # of hours

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"E. Lewis" wrote in message ...
| 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.