Adding times
- From: mel_flynn <mel_flynn.1zb5p6_1133351124.4344@xxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 30 Nov 2005 05:41:42 -0600
I'm trying to add the following list of times:
09:30 + 09:00 + 09:00 + 04:00 + 08:30 + 08:30 + 06:00 + 05:00 + 05:00 +
07:00 + 08:00 + 05:00 + 04:00 + 07:30
Using the following formula:
=IF(INT(ROUND(SUM(L4:L70)/0.04166667,2)) = 0, "",
INT(ROUND(SUM(L4:L70)/0.04166667,2)) &":" &
IF(MINUTE(MOD(SUM(L4:L70),1)) < 10, "0" & MINUTE(MOD(SUM(L4:L70),1)),
MINUTE(MOD(SUM(L4:L70),1))))
The problem lies in the part of the function marked in bold. This
function is working perfectly with all/most other combinations of
times.
Hopefully someone can help me.
Thanks,
Imelda.
--
mel_flynn
------------------------------------------------------------------------
mel_flynn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29206
View this thread: http://www.excelforum.com/showthread.php?threadid=489378
.
- Follow-Ups:
- Re: Adding times
- From: Jerry W. Lewis
- Re: Adding times
- From: Niek Otten
- Re: Adding times
- Prev by Date: Re: Formula to replace nos. below 100??
- Next by Date: Re: Need help with simple formula....
- Previous by thread: simple but can't seem to do -help please
- Next by thread: Re: Adding times
- Index(es):
Relevant Pages
|
