Please HELP...nervous wreck time calculation

[Madcap]

(I.)
I have a "calculator" set up on a worksheet that is set to calculat
the days, hours, and minutes; in duration; between two time stamps
i.e.

Start time = 4/24/2004 16:45

End Time = 4/26/2004 18:00

I use this formula to calculate my answer:
=INT(K15-K13+0.000001) & " Days," & MOD(INT((K15-K13)*24+0.000001),24)
& " Hours," & MOD(ROUND((K15-K13)*1440,0),60) & " Minutes"

And I get:
2 Days,1 Hours,15 Minutes

(II.)
What do I need to set the right-click and "format cells..." selectio
on in order to measure in time *DURATION* and not an actual moment i
time? I hope that makes sense.

(III.)
What would a formula look like that would take an answer like "2 Days,
Hours,15 Minutes" and add it to another similar variable with a sam
format SUM?
i.e. "2 Days,1 Hour,15 Minutes" + "3 Days,23 Hours,10 minutes" = "
Days,0 Hours,25 Minutes".

(IV.)
What would a formula look like to accumulate a collective *duration* o
those times by adding several sums, and only adding those sums if the
were greater than "2 Days,12 Hours,30 Minutes"?


Any help on any of these segments would be greatly appreciated. Than
You

 

[Frank Kabel]

Hi
II. Not sure what you mean with this question. Maybe you
can give an example

III. For this I would use a user defined function. But you
may consider a different approach (if you could live with
the fact that your result is only given in hours and
minutes)
- Enter the formula
=K15-K13
- format this resulting cell with the custom format [hh]:mm

These results can easily be added or summed. If you need
to display them in your format from your previous formula
you could use the following formula in a helper columne
=INT(K16) & "Days " & FORMAT(MOD(K16,1),"hh:mm")
If K16 stores one of these values

IV. See III

 

[Madcap]

(II.) What I'm trying to do is as follows:

When I add 12 hours......+
11 hours......
the sum turns into 23 hours.....

I need to see 23 cummulative hours, but the cell indicates 11:00 PM

 

[Frank Kabel]

Hi
just format the cell with the custom format
[hh]:mm