here i send my offer without macros. Sorry for my english.
HEP


Jay wrote:
*I have a comlicated formula that I need to develop and
I'm looking for some help. I have two cells that contain
a start time and an end time. I need to calculate the
total time between the two times and place the value into
the approipriate time slot. i.e. if the start time is
09:15 and the end time is 11:30 the value in the 09-10
cell would be 45 and the value in the 10-11 cell would be
60, and the value in the 11-12 cell would be 30. Any
ideas or hints. Thank you.

Attachment filename: problema complejo de horarios.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=39367
--
Message posted from http://www.ExcelForum.com