Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
Recently I was asked how to subtract time in Excel (time difference) or how to calculate the number of hours between two points in time on different days. Since this was in a reader comment, I gave a …
Continue Reading about How To Calculate Hours Between Two Dates in Excel →
Sometimes you need to extract the integer portion of a number. Sometimes the fractional part. Sometimes both. Excel makes it easy to get the integer and somewhat harder to get the fraction. If you …
Continue Reading about Extracting Integers and Fractions in Microsoft Excel →
I had a reader comment on my last post about how to extract time from a date-time number using the MOD function. Simple really. The syntax is MOD(number,divisor). The MOD function returns the …
Continue Reading about Extract Time with the MOD Function in Excel →
I have a worksheet that tracks start and stop times for different events throughout the day, all during the week. Sometimes I have to pull out the Time of Day, irrespective of the Date, with the TIME …
Continue Reading about Extract Time from a Date-Time Number in Excel →
I recently saw a spreadsheet with the following function =LEFT(A2,8) where cell A2 was equal to 08/06/12 12:23 PM. The user was trying to extract the Date from the Date-Time value. The problem for me …
Continue Reading about Extract a Date from a Date-Time Number in Excel →
I like to use a PivotTable to figure out simple problems in Excel. So for this post I'm going to use Excel 2011 (Mac), where PivotTable controls look funky when compared to their Windows …
Continue Reading about Pay Periods and Funky PivotTable Controls →
