How to Add Payroll Hours & Minutes in Excel

Next Video:
How to Annotate Excel Charts....5

Adding payroll hours and minutes into a document in Excel will require the right use of the appropriate tools. Add payroll hours and minutes in Excel with help from a self-taught web developer in this free video clip.

Part of the Video Series: Basics of Microsoft Excel
Promoted By Zergnet


Video Transcript

Hi, I'm Christina Chu. I'm a computer web specialist, and today I'm going to show you how to add payroll hours using Microsoft Excel. So we open Microsoft Excel here. You'll see our time, which is eight hours 30 minutes, four hours 20 minutes, three hours, 45 minutes, five hours, 20 minutes. Now Microsoft Excel, when that recognizes as time it'll recognize it as integers, so to convert it to a time to integers, simply select a slot right here and within the formula insert tab bar, you'll select and put in our formula to convert it to integers as equals inside a two minus int a two close that and close this one multiplied by 24 select enter and now it's going to convert it into a decimal. So now to incorporate that into the other cells without having to retype it, simply select this over here. Move your mouse to the lower right hand corner till you see a black plus sign and then scroll that down to the other cells. And now they're all converted to decimal points. Now to get the sum of all that right there, select the cell you want to put the sum to, so if you want to select that, and then input the formula which will be equals sum of b. Press enter and there is the sum of hours and minutes in decimal form. So that is how you add payroll hours and minutes to Microsoft Excel. Thanks so much for your time and I appreciate you.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!