Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6963 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I know this is going to sound silly, but My brain has turned to mush. I'm building a project manager in one of my solutions. Each action item has a field that allows the user to plug in the number of minutes that action item will require. I'm building another field that will calculate the sum of all of these action items and give me the total time (in hours and minutes) these action items will require.

I will not bore you with the details, but lets just say that this small calc is a little pebble in my shoe that has finally demanded my attention. I'm not sure what I'm doing wrong but I can't get the field to display the correct hours:minutes properly. I'm sure I'm overlooking something so incredibly obvious that I'm emberrassed to even be posting this, but my brain is now numb and I need help. Anyone have a suggestion?

Posted

Hi

assuming that you have three number fields, holding seconds, you can try this:

GetAsTime( seconds1 + seconds2 + seconds3 )

If you wish to enter minutes, the calc becomes:

GetAsTime( minute1 * 60 + minute2 * 60 + minute3 * 60 )

Posted

I just have one number field. One task may take 5 minutes, another may take 30. Another may take 15 etc.... I need to be able to see in a total in hours and minutes.

Posted

Ok

so you have one record for every task, each holding a number field: minutes

make a new summary field: summaryMinutes = total of minutes

Make another one (calculated result time):Total = GetAsTime( Sum ( SummaryMinutes ) * 60 )

this will sum all fields minutes in the found set of records

This topic is 6963 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.