Workout decimal time

[JPHenning]

Hi

Can someone tell me how I change the time to decimal time when I have a the following table and formula

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 76px"><COL style="WIDTH: 64px"><COL style="WIDTH: 81px"><COL style="WIDTH: 81px"><COL style="WIDTH: 81px"><COL style="WIDTH: 81px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD> </TD><TD>Date</TD><TD>Start Time</TD><TD>Break out</TD><TD>Break in</TD><TD>Finish time</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>Sunday</TD><TD> </TD><TD style="TEXT-ALIGN: right">08:00</TD><TD style="TEXT-ALIGN: right">10:15</TD><TD style="TEXT-ALIGN: right">11:00</TD><TD style="TEXT-ALIGN: right">17:00</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>Monday</TD><TD> </TD><TD style="TEXT-ALIGN: right">12:00</TD><TD style="TEXT-ALIGN: right">13:30</TD><TD style="TEXT-ALIGN: right">14:00</TD><TD style="TEXT-ALIGN: right">18:00</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

In cell H3 I use =SUM((F3-C3)-(E3-D3)) which gives me 08:15 which is the hours worked I need this as a decimal 8.25 hours worked.

How di I do this?

 

[jasonb75]

=SUM((F3-C3)-(E3-D3))*24

Change cell format to number.

 

[JPHenning]

=SUM((F3-C3)-(E3-D3))*24

Change cell format to number.

Thanks

 

[barry houdini]

Also SUM function is redundant, this is sufficient

=((F3-C3)-(E3-D3))*24