Formula and field types for calculating times

  • Thread starter Thread starter Hans-Martin Burger
  • Start date Start date
H

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)
 
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)
 
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)
Click to expand...

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