Re: Adding times
- From: "Niek Otten" <nicolaus@xxxxxxxxx>
- Date: Wed, 30 Nov 2005 13:17:36 +0100
It is not clear to me what you're trying to do.
Why not just SUM the times and format as time or Custom format as [h]:mm?
--
Kind regards,
Niek Otten
"mel_flynn" <mel_flynn.1zb5p6_1133351124.4344@xxxxxxxxxxxxxxxxxxxxx> wrote
in message news:mel_flynn.1zb5p6_1133351124.4344@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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
>
.
- References:
- Adding times
- From: mel_flynn
- Adding times
- Prev by Date: Re: Is Gary's Student here
- Next by Date: Re: Cell content in custom header: How?
- Previous by thread: Adding times
- Next by thread: Re: Adding times
- Index(es):
Relevant Pages
|
