| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need formula to calculate time difference
Hi Marcelo,
To help you tie in how the formulas that were supplied as answers work, you should be aware that time is a fraction of a day. So 6 hours is .25 days, and 20 minutes is =20/(24*60) of a day. Dates are measured as days past a reference date. You can read more about Date and Time and their calculations in http://www.mvps.org/dmcritchie/excel/datetime.htm http://www.cpearson.com/excel/datetime.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate the difference in time? | Excel Worksheet Functions | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Calculate time difference between cells | Excel Discussion (Misc queries) | |||
| How can I use a time difference in a subsequent formula in Excel? | Excel Worksheet Functions | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Hybrid Mode
