Hi Hector!

We got it all working OK off newsgroup in the end.

The key formula was:

=IF(C1="","",IF($A2<C1,IF($B2D1,60,IF($B2<C1,0,($ B2-C1)*24*60)),IF($A
2D1,0,IF($B2D1,(D1-$A2)*24*60,($B2-$A2)*24*60))))

A2 contained the start date and time and B2 contained the stop date
and time.

We managed a copy down OK and a summing of the results.

The file of 10000 records is a bit big but I've suggested using
monthly files and then a summary file.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"HÉCTOR E. POLLA" wrote in
message ...
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=393678
---
Message posted from http://www.ExcelForum.com/