how do I show the total of difference between two times in decima.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


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

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

Mike
 
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

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