On Thu, 14 Mar 2013 23:19:38 +1100, Living the Dream
wrote:

Hi Emile

The way I see it is you can do this using Helper Cells.

Using your current Date/Time Format:

A2 = Start Date/Time
B2 = Finish Date Time
C2 = "=(($B2-$A2)*24)-(ROUND(($B2-$A2),0)*7)"

*Remove the double quotes from C2

HTH
Mick


One must be sure to make the time entries in 24 hr format as well, no?