Build a excel forumla

I want someone to creat a excel formula where I will punch in the clock in and clock out for my employee and on the other tabs it will cover the actual time and round it to the nearest 5 & 7 minutes interval so I can compare and monitor time clock rounding.

I have attached the sample data sheet, I would like somone to convert the formula that will populate the time in and outs based on the clock in times and also meet with legal guidleines of clock rounding.

Law Summary so it helps understand the concept

[login to view URL]

Skills: Accounting, Data Entry, Data Processing, Excel, Finance

See more: build excel macro find replace, excel macro open web page populate form read results, charge build excel databases, how to create a custom formula in excel, microsoft excel formulas list with examples, excel formulas cheat sheet, complex excel formulas, excel formulas, excel formulas pdf, creating complex formulas in excel, how to insert formula in excel for entire column, build excel ui, excel formula calculation digits convert digits, build excel calculator php, build excel reports php mysql, build excel pivot table text file, aspnet build excel pivot table, build excel vba functions, excel form web form convert, excel forumla rank figures

About the Employer:
( 0 reviews ) United States

Project ID: #17149246

Awarded to:


Hello there, I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. More

$30 USD in 3 days
(151 Reviews)

7 freelancers are bidding on average $24 for this job


Hello, I’m an Excel expert and I would like to help you with your formula. Please send me a message so that we can discuss more.

$30 USD in 1 day
(267 Reviews)

Hi, I am interested in working on this task. Saw the file attached. Can develop a macro which will automatically round of as per the table Is the rounding off to be done only in the first sheet as given in the sam More

$23 USD in 1 day
(25 Reviews)

I can help you with the formula, so please, contact me if you want to know more about details Thank you very much for your time.

$15 USD in 1 day
(8 Reviews)

Hello. I have good skills in Excel. Contact me please. Thanks......................................................................

$25 USD in 1 day
(1 Review)

i am an expert with excel formulas cause im currently handling a company database using excel . With the help of formula i did in excel and pivot table i could easily do the reporting

$25 USD in 1 day
(0 Reviews)
$20 USD in 1 day
(0 Reviews)