HDTutorial
EN
How to create a Timesheet in Microsoft Excel. Create a 24 hr automated timesheet.

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to create a Timesheet in Microsoft Excel. Create a 24 hr automated timesheet.

2,801 views September 14, 2020 16:51

Watch on YouTube
ChannelITsEasyTraining1st

Description from the creator

This video explains how to create a basic timesheet and a 24hr timesheet in Microsoft Excel. The tutor explains how to use formulae to work out hours worked and overtime worked. The tutorial covers how to format cells to hours and calculate wages based on the hours worked.

Functions used in this video are the IF statement and AutoSum
Formatting explained in this video are: Time and date, Hours [h]:mm:ss
Other features: Password Protection and Templates
Key Command Used Ctrl +1 to activate format cells



Most popular video at the moment: Spill Error youtube.com/watch?v=uyNXVbpfsiE
Play list for this video: youtube.com/playlist?list=PLK99llucAWlt5BjHVQwl…

Intermediate Excel course online itseasytraining.teachable.com/p/excel-intermedi…

Excel for New Managers, written by Steve Saxton is available here: amazon.co.uk/Excel-New-Managers-understanding-M…

#itseasytraining
#excelcourses

Training at itseasy.co.uk/
Online courses at itseasytraining.co.uk/

About this tutorial

ITsEasyTraining1st published this 16:51 video tutorial on September 14, 2020. It has been watched 2,801 times on YouTube.

Duration
16:51
Published
September 14, 2020
Views
2,801
Likes
11

Tags

Share

This tutorial in other languages