Prev: SelfCert
Next: Referencing conditional format is another workbookHI
From: Mayte on 4 Jun 2010 13:39
Hi -
i have to find out how long did it take to solve a case. the formaul is
(time completed) - (time created) my problem is when files are closed at
midnight because of the format ... any ideas how to fix it???

Column A = time created
Column B = time completed
Column C = Duration (in hours only)

timeCreated timeCompleted Duration
04/07/2010 15:00:00 04/07/2010 00:00:00 should be 9:00:00

Cheers,
Mayte
From: Jackpot on 4 Jun 2010 13:46
04/07/2010 15:00:00 is bigger than 04/07/2010 00:00:00

Try

04/07/2010 23:59:59 in A1 and 00:00:01 in cell B1 and try formula A1+B1

04/07/2010 23:59:59 is followed by 04/08/2010 00:00:00


So the below formula should work fine.
=B1-A1

and format the formula cell to [h]:mm:ss


"Mayte" wrote:

> Hi -
> i have to find out how long did it take to solve a case. the formaul is
> (time completed) - (time created) my problem is when files are closed at
> midnight because of the format ... any ideas how to fix it???
>
> Column A = time created
> Column B = time completed
> Column C = Duration (in hours only)
>
> timeCreated timeCompleted Duration
> 04/07/2010 15:00:00 04/07/2010 00:00:00 should be 9:00:00
>
> Cheers,
> Mayte
From: Mayte on 4 Jun 2010 14:58
it wooooooooooooorks!!!!

thanks mate!
 | 
Pages: 1
Prev: SelfCert
Next: Referencing conditional format is another workbookHI