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?

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 )

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.

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

In your Projects table, define a calculation field (result is Time) =

Sum ( ActionItems::Minutesfield )

Thanx,

That did it.