=MOD(end-start,1)

or


=end-start+(startend)


--


Regards,


Peo Sjoblom


"richardandre" wrote in message
...
i need to calculate hours and minutes between eks. "clock" 18:30 and
03:30
into hh:mm
it does not take into account that it's 9 hours not 14,5

excel 2003