Microsoft Excel Tutorial for Beginners #23 - Date & Time Pt.4 - Time Calculations & Formatting

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
16,712
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jun 27, 2011

Visit MotionTraining at http://www.motiontrainingweb.com
Learn how to enter and format times as well as perform common time calculations. More tutorials soon.

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (MotionTraining)

  • I think that @inakisc meant that the Wizard of Oz has the wrong end time. the time is off. Any way to fix that?

  • @stargzr What time did you expect to see in cell G10?

  • @MotionTraining Wow. Never mind. I just realized that I mistook 12:56 pm for 12:56 am. I'm too used to a 24 hour clock here in France. Thanks for the quick response. By the way, I really appreciate the concise directions. I've been through 23 of your tutorials today and made all the spreadsheets. :) Thanks!

  • @stargzr No problem and thanks for the comment. Glad to hear the tutorials have helped you. I plan to have a few new videos up this week, so stay tuned!

  • Hello and thank you so much for the tutorials! I've learned so far and I hope you'll keep up with making them. Got one question: do you plan in the near future to make tutorials for the pivot tables as well? That would help a lot!!! You make Excel look easy to l, so please, make for the pivot tables, too! Best regards, Irina.

  • @ChisanaButterfly Hi. Thanks for the kind words and yes, Pivot Tables are on my 'to do' list! Not sure exactly when, but it will be before the end of March.

see all

All Comments (20)

Sign In or Sign Up now to post a comment!
  • @MotionTraining Thanks! That worked great!

  • very good , where is the 24th ect. , cant wait to see them...

    thanks

  • How do you calculate the time difference between 10pm and 7am the next day?

  • are there only 23 tutorials? I am unable to find the 24th one..........please help......anyway thanks a lot........i want to know about the vlookup,hlookup and pivot table.....would yyou please help in it?

    

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more