Calculate hours and minutes worked

Question

Hi everyone, I'm hoping someone can help me with this.

I'm looking to add up my hours and minutes I've worked into a total box on a job sheet, so in one day if I've spent 3 hours, I enter 3.0, then the next day I worked 1 hour and 55 minutes I will enter 1.55 then if the next day I work 25 minutes I will add 0.25. the total box will sum these up to 4.8, but I'm wanting to keep the hour minute format, so want to to sum it to 5.20.

Is this possible?

Nesa Nurani · Accepted Answer

Try this as 'Custom calculation script' of "Total" field:

var totalMinutes = 0;

for(var i=1; i<=21; i++){
 var time = this.getField("TimeRow" + i).valueAsString;
  if(time){
   var parts = time.split('.');
   var hours = parseInt(parts[0]);
   var minutes = parts[1] ? parseInt(parts[1]) : 0
   totalMinutes += hours * 60 + minutes;}}

var totalHours = Math.floor(totalMinutes / 60);
var remainingMinutes = totalMinutes % 60;

event.value = totalHours + '.' + (remainingMinutes < 10 ? '0' : '') + remainingMinutes;

Jimmy37778549g0fm · Answer

Hey there! I completely understand your frustration with keeping track of work hours in both hours and minutes. Here are a couple of approaches you can take:

Use a dedicated time tracking tool: Many project management or time tracking apps can handle these calculations automatically. They often offer features like start and stop timers, automatic breaks, and reports that can be helpful for managing your workload.
Manual calculation with conversion: If you prefer a manual approach, you can convert your minutes to decimal hours before adding them. For example, 1 hour and 55 minutes becomes 1.92 hours (1 hour + (55 minutes / 60 minutes)). Then, you can simply add these decimal values to get your total time.

Bonus tip: If you're looking for a quick online tool to convert between time formats or perform basic time calculations, check out Date and Time Calculator It's a free resource that can be handy for situations like this!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded