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

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

Guest

Hi


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

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

Mike
 
N

Niek Otten

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference between two times in seconds 1
Difference Between Two Times 4
Caluculate difference between two times 7
Calculating total elapsed minutes between two dates 1
Summary of Difference between dates in years, months, days 3
How to calcuate the difference between two times in tenths of a mi 1
Difference between dates and times 5
Calculate the difference betwen two columns -two dates 3

Top