View Single Post
  #7   Report Post  
Steved
 
Posts: n/a
Default

Hello from Steved

I've found a solution

DOLLARFR(DOLLARDE(M306,60)-DOLLARDE(C306,60),60)

Cheers.

-----Original Message-----

9.00 - 7.00 returned 120 for me. Try formatting the

decimal time column
as text (making sure that 2 decimal places are shown)


--
crispbd
----------------------------------------------------------

--------------
crispbd's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=10880
View this thread:

http://www.excelforum.com/showthread...hreadid=320247

.