| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula and field types for calculating times
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) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula and field types for calculating times
=24*("12:30"-"8:15")
and format as General -- Gary''s Student - gsnu2007d |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula and field types for calculating times
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 "Hans-Martin Burger" wrote in message ... | 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) |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula and field types for calculating times
On Feb 6, 10:42 am, "Niek Otten" wrote:
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 "Hans-Martin Burger" wrote in ... | 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| 2 data types (same col/dif times), do: custom? parse? 2col? | Excel Discussion (Misc queries) | |||
| Which formula is correct for calculating times? | Excel Discussion (Misc queries) | |||
| Pivot table field types | Excel Discussion (Misc queries) | |||
| How can I format the #of decimals, field types, etc. automaticall. | Excel Discussion (Misc queries) | |||
Linear Mode
