Formula and field types for calculating times

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hans-Martin Burger - 06 Feb 2008 10:32 GMT

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)

Reply to this Message

Gary''s Student - 06 Feb 2008 10:42 GMT

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

Signature

Gary''s Student - gsnu2007d

Reply to this Message

Niek Otten - 06 Feb 2008 10:42 GMT

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

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

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello,
|
[quoted text clipped - 6 lines]
|
| 12:30 - 08:15 = 4.25 (4 hours and 15 minutes)

Reply to this Message

Matt Richardson - 06 Feb 2008 15:35 GMT

> To learn all about calculating with time, visit Chip Pearson's site:
>
[quoted text clipped - 16 lines]
> |
> | 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

Reply to this Message