Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculating time/dates differences
I'm looking for a formula that will allow me to calculate the difference
between the time and date of one day and the next. I also need to be able subtract out the time between 17:00 ahd 08:30 as well as weekend days and holidays. Example 6 June 16:51 to 7 June 9:51 |
#2
|
|||
|
|||
Here's some formulas and information that might help:
http://www.officearticles.com/excel/...soft_excel.htm The most important part is the formatting of the cell that contains the formula. Also, when you subtract dates/time, the answer is provided in DAYS. So if you want the number of hours, you have to add /24 to the end of your formula. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "fvglassman" wrote in message ... I'm looking for a formula that will allow me to calculate the difference between the time and date of one day and the next. I also need to be able subtract out the time between 17:00 ahd 08:30 as well as weekend days and holidays. Example 6 June 16:51 to 7 June 9:51 |
#3
|
|||
|
|||
"Anne Troy" wrote in message news:562ac$42b9d7e0$97c5108d$8584@allthenewsgroups .com... Also, when you subtract dates/time, the answer is provided in DAYS. So if you want the number of hours, you have to add /24 to the end of your formula. I think you mean *24 Anne :-) |
#4
|
|||
|
|||
Uh. Thanks, Bob! :)
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Bob Phillips" wrote in message ... "Anne Troy" wrote in message news:562ac$42b9d7e0$97c5108d$8584@allthenewsgroups .com... Also, when you subtract dates/time, the answer is provided in DAYS. So if you want the number of hours, you have to add /24 to the end of your formula. I think you mean *24 Anne :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not calculating correctly | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating differences between dates | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) |