Meeting

Learn about:
1.What time is in Excel
2.Time in Excel is a decimal between 0 and 1, and the decimal represents the proportion of one 24 hour day that has elapsed
3.Time Number Format sits on top of the decimal
4.The decimal is used in time calculation formulas, not the formatted number
5.Payroll time Calculation
6.Day Shift Time Worked Calculation: End Time Start Time
7.Night Shift Time Worked Calculation: MOD function
8.Round Time to the nearest 5 minutes with ROUND or MROUND functions
9.Add Time above 24 hours using custom Number formatting
10.Add Time above 24 hours using formula and the number 24 and General Number Format

Duration : 0:13:8

[youtube tYw8NVuqs30]

6 Responses

1. ExcelIsFun Says:
   July 9th, 2010 at 7:40 am

   Watch this video:
   …
   Watch this video:

   Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time)

2. b1ack3heart Says:
   July 9th, 2010 at 7:40 am

   How do i use the …
   How do i use the rounding method using the grave shift formulas?

3. ExcelIsFun Says:
   July 9th, 2010 at 7:40 am

   You are welcome!
   You are welcome!

4. nsxt290 Says:
   July 9th, 2010 at 7:40 am

   Very good tutorial! …
   Very good tutorial!! THanks for this

5. ExcelIsFun Says:
   July 9th, 2010 at 7:40 am

   Wow, planiolro, you …
   Wow, planiolro, you are a really smart Excel guy – was there some new stuff in this video that you learned from, or was it just the comprehensive nature of the video that was of interest to you.

   Since I always get so many questions about time, my intention was to make one video that had most of the time tricks so that I could always send people to this one video…

6. planiolro Says:
   July 9th, 2010 at 7:40 am

   Calculating time is …
   Calculating time is always difficult if you do not how the deal with the format.Therefore the video clarify how calculation should be done. As always an very useful video

Leave a Comment