Home // Blog & Excel Tips // Using Excel’s TIME functions

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

Using Excel’s TIME functions

Comments Closed
Uncategorised

A visitor wrote

do you have a tutorial for entering timesheets
eg, i want 7:00 -12:00 =5hrs
is there a formula that will take my in and out times and figure out the total hours

Then at the end of each week if the total hours is over 44 i want it to default the rest into overtime

There are a number of TIME functions in Excel. If you watch the function wizard video clip on https://www.auditexcel.co.za/Function%20Wizard%20Project.html you can access all of Excel’s time functions which are easy to understand.

Once you have that sorted you can use a IF function to work out if you are over 44 hours and then allocate the additional hours to overtime. You can also watch how to use the IF function on https://www.auditexcel.co.za/IF.html