On Mon, 25 Apr 2005 21:51:30 +0000 (UTC), "Martin B"
wrote:


Sorry perhaps I didn't make it clear in my original posting. This is
something I have to do everyday and I always type in the start day and time,
eg Monday 15:00 and a duration. I would dearly like the spreadsheet toadd
the duration to the start day and time and display the finish day and time.
I have no interest in the date so don't want to have to enter it multiple
times.

Hope this is a little clearer

Thanks
Martin


Assumptions:

Using 1900 date system
A1: Monday (or Day of Week)
B1: 15:00 (or any time)
C1: Number of hours

Formula:


=SUM(MATCH(A1,{"Sunday","Monday","Tuesday","Wednes day","Thursday","Friday","Saturday"},0),B1,C1/24)

Format result as Format/Cells/Number Custom Type: dddd hh:mm

If this might be on machines using either the 1900 or 1904 date systems, then
use this formula instead:

=SUM(DATE(2000,1,1)+MATCH(A1,{"Sunday","Monday","T uesday","Wednesday","Thursday","Friday","Saturday" },0),B1,C1/24)


--ron