hours used
 

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

hours used
 

=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

hours used
 

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


"Peo Sjoblom" wrote:

=MOD(end-start,1)

or


=end-start+(startend)


--


Regards,


Peo Sjoblom