hours used

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

richardandre - 12 Nov 2007 21:59 GMT

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

Reply to this Message

Peo Sjoblom - 12 Nov 2007 22:08 GMT

=MOD(end-start,1)

or

=end-start+(start>end)

Signature

Regards,

Peo Sjoblom

>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

Reply to this Message

richardandre - 12 Nov 2007 22:17 GMT

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

> =MOD(end-start,1)
>
> or
>
> =end-start+(start>end)

Reply to this Message

Rate this thread: