values > 24/48 hours

[Roberta]

I have a work sheet where start/stop times are entered in mm/dd hh24:mm
format in colummns I and J. I have another column (K) that calculates
hours/minutes of each row - with j1 - i1 and format of [h]:mm;@ and it shows
correct hours/minutes even when above 24 or 48 hours. I have several
subtotals at different points - e.g. K10 defined as sum(k1:k9), k18 (sum of
K11:k17), etc. When I try to add the sub-totals, I can't get total hours and
minutes the way I'm trying to. K10 totals to 84:10 and K18 totals to 13:13,
but my grand total is 192505.23 (format of [h]:mm;@) or 1:23 (format of
hh:mm) - I've tried several other formats but can't get 97:23.

It's probably something simple that I'm missing, but in looking at other
posts it looks like the format I'm using of [h]:mm;@ or even [hh]... should
work, but it's not.

If anyone knows what I'd doing wrong, please let me know.

 

[daddylonglegs]

Hello roberta. A simple format of [h]:mm should work. What formula are you
using to add the subtotals? Are you sure K18 is formatted correctly as [h]:mm?

 

[Roberta]

Thanks. I went back and checked - my original "template" was set up
correctly. But someone was using it and they changed formats for a couple
rows. Once I went back and changed format for all, it's now working OK.

Had me confused - I just didn't go back to the source, assuming it hadn't
changed....

Hello roberta. A simple format of [h]:mm should work. What formula are you
using to add the subtotals? Are you sure K18 is formatted correctly as [h]:mm?

I have a work sheet where start/stop times are entered in mm/dd hh24:mm
format in colummns I and J. I have another column (K) that calculates
hours/minutes of each row - with j1 - i1 and format of [h]:mm;@ and it shows
correct hours/minutes even when above 24 or 48 hours. I have several
subtotals at different points - e.g. K10 defined as sum(k1:k9), k18 (sum of
K11:k17), etc. When I try to add the sub-totals, I can't get total hours and
minutes the way I'm trying to. K10 totals to 84:10 and K18 totals to 13:13,
but my grand total is 192505.23 (format of [h]:mm;@) or 1:23 (format of
hh:mm) - I've tried several other formats but can't get 97:23.

It's probably something simple that I'm missing, but in looking at other
posts it looks like the format I'm using of [h]:mm;@ or even [hh]... should
work, but it's not.

If anyone knows what I'd doing wrong, please let me know.