THIS CONTENT IS NOW HOSTED ON GITHUB: https://github.com/sweenig/ipfromdec/
Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
Tuesday, March 17, 2015
Friday, May 27, 2011
Excel and Dates
While recently working on some data, i recently stumbled across some formulas that i found useful:
Excel handles dates as numbers. Basically the number of days since 1/1/ 1900 0:00. The decimal portion of the number represents the hours and minutes within the day. For example today is 40556.64462. So, if i wanted to subtract the number of hours until quitting time, i'd need to subtract 40556.64606 from 40556.70833. This is fairly easy.
Excel handles dates as numbers. Basically the number of days since 1/1/ 1900 0:00. The decimal portion of the number represents the hours and minutes within the day. For example today is 40556.64462. So, if i wanted to subtract the number of hours until quitting time, i'd need to subtract 40556.64606 from 40556.70833. This is fairly easy.
Sorting Excel data using formulas
Sometimes, you sort data in excel. This is handy since the order provides a framework around which our mind can be wrapped. However, it's not always handy to have to select the cells you want to sort and use the menus to sort them. Sometimes, it would be handy to sort the data automatically.
Removing the protection from Excel workbooks
I get frustrated from time to time when i'm forced to use a mediochre Excel spreadsheet. For example, i have a spreadsheet that i have to fill out from time to time. I put in between 3 and 10 entries and have to number them. This is the most annoying thing. The first thing i did was open the original template and insert the following formula into A2:
Subscribe to:
Posts (Atom)