![]() It doesn't use helper columns - I have hard-coded the shift patterns instead. I ended up with this, working off the sheet in post #32. The DATEDIF function is useful in formulas where you need to calculate an age. By default, Januis serial number 1, and Januis serial number 39448 because it is 39,447 days after January 1, 1900. I have tried B1-A1-1:45, B1-A1-01:45, and B1-A1-1.75 but none of these work. Dates are stored as sequential serial numbers so they can be used in calculations. Instead of C1 being the exact duration, I want it to be the duration minus 1 hour and 45 minutes. The DATEDIF () is not documented in Excel 5, 7 or 97, but it is in 2000. The calculation uses the DATEDIF () function. ![]() Age Calculation You can calculate a persons age based on their birthday and todays date. ym Number of whole months when subtracting years from the difference of Start date and End date. You can use it to find the difference in days/months/years between two dates. ![]() y Number of whole years between Start date and End date. m Number of whole months between Start date and End date. As with JeteMc it seemed like there should be a neater solution but it turned out the code got a lot longer to deal with the weekend bit. Cell C1 contains the formula B1-A1, which returns the difference between the times (which gives me the duration of an event). d Number of whole days between Start date and End date.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |