Formula and field types for calculating times

[Hans-Martin Burger]

Hello,

I don't get it how to format fields and apply some formula to calculate
with time-differences.

Example:
I want the difference of two time fields expressed as
decimal-number.

12:30 - 08:15 = 4.25 (4 hours and 15 minutes)

 

[Gary''s Student]

=24*("12:30"-"8:15")
and format as General

 

[Niek Otten]

To learn all about calculating with time, visit Chip Pearson's site:

http://www.cpearson.com/excel/datetime.htm#AddingTimes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello,
|
| I don't get it how to format fields and apply some formula to calculate
| with time-differences.
|
| Example:
| I want the difference of two time fields expressed as
| decimal-number.
|
| 12:30 - 08:15 = 4.25 (4 hours and 15 minutes)

 

[Matt Richardson]

To learn all about calculating with time, visit Chip Pearson's site:

http://www.cpearson.com/excel/datetime.htm#AddingTimes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hello,
|
| I don't get it how to format fields and apply some formula to calculate
| with time-differences.
|
| Example:
| I want the difference of two time fields expressed as
| decimal-number.
|
| 12:30 - 08:15 = 4.25 (4 hours and 15 minutes)

If you have 12:30 in cell A1, 08:15 in cell B1, and then the formula
=A1-B1 in cell C1, Excel will give the response 04:15.

Is this what you mean? If you want it in a decimalised format, try
the following formula in cell C1:-

=HOUR(A1-B1)+MINUTE(A1-B1)/60

And ensure that the number format of the field is set to General or
number.

Hope this helps,
M.Richardson
http://teachr.blogspot.com