Calculate time same day and multiple days

i have a formula i have been using for awhile and i need to tweak it and cannot find a solution in other posts.

Part 1
A1 = Date Manually entered (Date formatted Monday, June 15, 2015)
B1 = Start Date (References A1 Date Formatted 6/15/15)
C1 = Start Time (Manually entered 8:00 AM)
D1 = End Date (Manually entered Date Formatted 6/15/15)
E1 = End Time (Manually entered 8:00 PM)
F1 = Total Time =((D1+E1)-(B1+C1))


this works when calculating within the same day, but sometime i need extend over multiple days and it become inaccurate.
i have tried to add *24 at the end but it hasn't worked.
how do i set this up for separate cell input of date and time for this calculation?



Part 2 of this question would be to enter in cell G1 the total time off to put the final total hours worked into cell H1
i am currently manually entering and figuring this out.


Screen shot attached is a partial view


Thanks in advance.
Drew


Screen Shot Excel Worksheet.png

Hello
Try custom formatting F1 as so:

Formula:

Please Login or Register  to view this content.

DBY

Winner! that worked!! i never thought about changing the format!
Thanks DBY

Now a question for bonus points

i can't figure out how to take F4 (time format) and subtract G4 (number format) to get a solution into cell H4 (number format)

using the above screen shot

F4 calculated form cells to the left (time format) = 11.00
G4 manually entered (number format) = 1.00
H4 manually entered (number format) = 10.00

trying to see the result in H4 and trying to automate the process!


thanks,
drew

And Thank You Tony!!

if you or other members cannot see the screen shot posted, was it an issue of file format? .png? would a .pdf or .jpg been better?

i have another question and will post it here as it continues on the above formulas...

this is based on the solution value in the H4 column.
i would like the ability to round up any value solved from the formula =(F4*24)-G4 that is above "0" but under "10" to round up to "10"
so if the first solution value is 8 then it would round up to 10

i have tried a few different variations and had no luck.



Thanks

.jpg it will be. thanks for that info

well that seems to round up all values within 10
if the "F4" solution value is 13 or 19, it rounds up to 20

i am trying to have only values above 0 and below 10 round up only those up to 10