Excel Magic Trick 501: Excel Time Format & Calculations (10 Examples)

[KHOLOUD911]

Brilliant !! very clear and did the job .. Keep going :)

[poerc]

Thank you for the awesome instructions! I admire anyone who can clearly get their point across.

[ExcelIsFun]

You are welcome!

[MrNyc1992]

=IF(ISERROR(IF(ISBLANK(A1),"",­IF(ISBLANK(B1),"",ROUNDUP(MOD(­ROUND((TEXT(B1,"00\:00")-TEXT(­A1,"00\:00"))*1440,0)/1440,1)*­24,1)))),"",(IF(ISBLANK(A1),""­,IF(ISBLANK(B1),"",ROUNDUP(MOD­(ROUND((TEXT(B1,"00\:00")-TEXT­(A1,"00\:00"))*1440,0)/1440,1)­*24,1)))))

this is the formulas that i am working with right how. 

[ExcelIsFun]

I am currently working 80+ hours week. No time. Try posting to THE best Excel question site:

mrexcel[dot]com/forum

[MrNyc1992]

HI i have a question for you. How do you get one tenths of hour every six min. here is any exmaple: 1400 2202 8.1

you every six minuets is one tenth of hour. Right how i have it round up after every one or two minuets.

[jasoncolman2002]

sorry how do i download the examples so i can work on the excel sheet?

[ExcelIsFun]

To learn how to download workbooks, search for and watch this video title:

excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks

[seal2bkl]

You are the man, great teacher, I wish I had someone like you for any of my classes in school, obviously in math or computers would have been the most helpful. Thanks!

[ExcelIsFun]

You are welcome!!!

[b1ack3heart]

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

[ExcelIsFun]

Watch this video:

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

[nsxt290]

Very good tutorial!! THanks for this

[ExcelIsFun]

You are welcome!

[planiolro]

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

[ExcelIsFun]

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...