How to Calculate Time

[henryyhw]

It works, thanks a lot for your help.

swatsp0p Wrote:
> Format cell C1 as Custom: dd/mm/yyyy hh:mm and enter this formula:
>
> =(A1+B1)-0.333
>
> returns 01/06/2005 21:15
>
> note that 8 hours is 0.333 of one day
>
> Does this work for you?
>
> Bruce
>
>
> --
> swatsp0p
>
>
> ------------------------------------------------------------------------
> swatsp0p's Profile:
> http://www.excelforum.com/member.php...o&userid=15101
> View this thread:
> http://www.excelforum.com/showthread...hreadid=375947


--
henryyhw

[swatsp0p]

I'm glad it worked for you. Thanks for the feedback, it is always appreciated.

Cheers!

Bruce