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

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

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" <(E-Mail Removed)> wrote in message news:1C8B660F-5502-40AF-946E-(E-Mail Removed)...
| 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.

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.