1:15 is shortly after midnight. 1:15 PM is shortly after noon. If you
want your code to always treat the second time as later than the first, you
can use an if statement

if endtime < starttime then endtime = endtime + timvalue("12:00")

- now do your calculation.

This assumes you won't have people working past midnight.

--
Regards,
Tom Ogilvy

"xlsxlsxls " wrote in message
...
Thanks a lot. This helps out a lot and at least gives me something to
work with. However, when I enter a start time of 9:00 to say 1:15 I
will get a wrong answer unless I use a formula as in the attachment
(unless I type in 13:15).

This is to track volunteer hours who generally come in in the morning
and work anywhere from 3 to 6 hours so I would like it in decimals
(e.g. 3.75, 4.25).

Thanks.


---
Message posted from http://www.ExcelForum.com/