I would like to create the following formulae:

A1: Start date/time e.g. Thursday 25/06/2009 08:00
B1: End date/time e.g. Thursday 25/06/2009 18:00
C1: Duration of break e.g. 01:00 (1 hour)
D1: B1 - A1 - C1 in hours

Any ideas?

If A1,B1 are in excel date/time format and C1 in time format

D1 = B1-A1-C
and format D1 to Customformat as below for hours and minutes

Right clickFormat CellsCustomType:
[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"Jon" wrote:

I would like to create the following formulae:

A1: Start date/time e.g. Thursday 25/06/2009 08:00
B1: End date/time e.g. Thursday 25/06/2009 18:00
C1: Duration of break e.g. 01:00 (1 hour)
D1: B1 - A1 - C1 in hours

Any ideas?

If you want decimal hours returned, use:
=(b1-a1-c1)*24

Format as General, or a number.

Regards,
Fred.

"Jon" wrote in message
...
I would like to create the following formulae:

A1: Start date/time e.g. Thursday 25/06/2009 08:00
B1: End date/time e.g. Thursday 25/06/2009 18:00
C1: Duration of break e.g. 01:00 (1 hour)
D1: B1 - A1 - C1 in hours

Any ideas?

I think it was working on Excel 2007 at home, however, at the office where
I'm also using Excel 2007, the value of the formula is being masked with
##########.

"Jacob Skaria" wrote:

If A1,B1 are in excel date/time format and C1 in time format

D1 = B1-A1-C
and format D1 to Customformat as below for hours and minutes

Right clickFormat CellsCustomType:
[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"Jon" wrote:

I would like to create the following formulae:

A1: Start date/time e.g. Thursday 25/06/2009 08:00
B1: End date/time e.g. Thursday 25/06/2009 18:00
C1: Duration of break e.g. 01:00 (1 hour)
D1: B1 - A1 - C1 in hours

Any ideas?

Normally one of two things:
1. Your column isn't wide enough. Make it wider.
2. You're trying to display a negative time. With your formula, that would
mean B1 is less than A1. Is it?

Regards,
Fred.

"Fred Smith" wrote in message
...
If you want decimal hours returned, use:
=(b1-a1-c1)*24

Format as General, or a number.

Regards,
Fred.

"Jon" wrote in message
...
I would like to create the following formulae:

A1: Start date/time e.g. Thursday 25/06/2009 08:00
B1: End date/time e.g. Thursday 25/06/2009 18:00
C1: Duration of break e.g. 01:00 (1 hour)
D1: B1 - A1 - C1 in hours

Any ideas?