Umesh Manral: Business Analyst, Excel VBA Automation Expert and Web Developer

The person behind Project Time Calculator, and why it was built: to track daily project tasks and save time.

I am Umesh Manral. I work as a Business Analyst, I build automation with Excel VBA, and I develop web applications. Project Time Calculator is a tool I made for my own daily project work, and I publish it so other people can use the same calculators for free.

What I do

• Business analysis. Turning a request into clear requirements, estimates and a plan, which is where most schedule questions start: how much effort, how many people and when it can realistically finish.
• Excel VBA automation. Replacing repetitive spreadsheet work, such as copying figures between sheets, building reports and checking data, with macros that run in seconds.
• Web application development. Building browser-based tools. This site is one: PHP is used only to assemble the pages, and every calculation runs in plain JavaScript on your device.

Why I built this tool

I created Project Time Calculator to track my daily project tasks. Every day I needed quick answers to the same small questions: how long was that task, how many hours did I work this week, what is left on the plan and what finish date does that give me. Doing them by hand or in a spreadsheet cost time and invited small mistakes, such as reading 7:30 as 7.30 hours.

So I put the formulas into calculators that I could open, fill in and trust. They help me, and they save me time. Because other analysts, project managers and students ask the same questions, I made them public and added the formulas and worked examples so anyone can check the result.

The tools I use most

These cover the daily routine of tracking tasks and planning what is left:

• Work hours calculator: paid hours for a shift, with an optional task log you can download as a CSV.
• Elapsed time calculator: the time between two moments, or several intervals added up.
• Add and subtract time: hours and minutes arithmetic with decimal-hour conversion.
• Task time estimator: effort, buffer and team capacity to a finish date and cost.
• Time remaining calculator: how much is left at the current pace.
• Project duration simulator: P50, P80 and P90 finish times from three-point estimates.

The full list is on the home page, and the about page explains what the site is and is not.

How the calculators are kept correct

Each formula has an automated test, and the numbers in every worked example are checked against the calculator code before the site is published. The methodology page lists the formulas and their assumptions. The calculators do not track your time for you, store projects or ask for an account: they calculate what you type and nothing else.

Corrections and questions

If a result looks wrong, send the inputs through the contact page. Confirmed errors are fixed and added to the tests so they cannot return.

Last updated 19 October 2026.