Hi All,

I would like to convert the duration into days... For example if i
have 56:32:48 (hrs:mm:ss), i would like to convert this into 2 days
8:32:48 or to any format which would describe this result. Thank you.

Cheers,sivaji

On 12 Jun., 07:10, siva <00siv...@gmail.com> wrote:
> Hi All,
>
> I would like to convert the duration into days... For example if i
> have 56:32:48 (hrs:mm:ss), i would like to convert this into 2 days
> 8:32:48 or to any format which would describe this result. Thank you.
>
> Cheers,sivaji

Hello,

=INT(A1)
will return number of days. You need to format this as number.

=MOD(A1,1)
will return the remainder.

Regards,
Bernd

On Jun 12, 2:10*am, siva <00siv...@gmail.com> wrote:
> Hi All,
>
> I would like to convert the duration into days... For example if i
> have 56:32:48 (hrs:mm:ss), i would like to convert this into 2 days
> 8:32:48 or to any format which would describe this result. Thank you.
>
> Cheers,sivaji

An alternate approach is to simply change the format to:
d:hh:mm:ss
to display:
2:08:32:48

On Jun 12, 7:55*am, Ron Rosenfeld <r...@nospam.net> wrote:
> On Sat, 12 Jun 2010 04:05:48 -0700 (PDT), James Ravenswood
>
> <james.ravensw...@gmail.com> wrote:
> >On Jun 12, 2:10*am, siva <00siv...@gmail.com> wrote:
> >> Hi All,
>
> >> I would like to convert the duration into days... For example if i
> >> have 56:32:48 (hrs:mm:ss), i would like to convert this into 2 days
> >> 8:32:48 or to any format which would describe this result. Thank you.
>
> >> Cheers,sivaji
>
> >An alternate approach is to simply change the format to:
> >d:hh:mm:ss
> >to display:
> >2:08:32:48
>
> At least in 2007 and earlier, that will not work for more than 31
> days.

Facinating!
is there any way to enter 35.234567
and have display as:
35:02:57:47
just by formatting (that is without changing the underlying numerical
value) ?