hours used

[Guest]

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

 

[Peo Sjoblom]

=MOD(end-start,1)

or


=end-start+(start>end)


--


Regards,


Peo Sjoblom

 

[Guest]

thanks worked fine (=end-start+(start>end))