Calculate Time Left in Total Hours of Logged

Dear Experts

Please help me in suitable formula, I tried =H4+12*24 But still i'm getting different answers. Please guide. I have attached the workbook for your reference

-sk

Try
=H4-SUM(E4:E6)

And format the cell with the formula as a TIME, not a number.

Thanks for response.

=H4-SUM(E4:E6) gives ######## as a result

That means it's a negative result (the sum of E4:E6 is greater than the time value in H4)
And excel doesn't really understand Negative Time, there's no such thing.

What do you want to happen in that situation?

Wait, it could also just mean that your column width isn't wide enough to display the time format you chose.
Widen the column...

E4:E6 = 6 hrs and 30 mins
Total Hrs Logged is 7 hrs and 19 mins
Total Time Left should be balance 30 mins +19 mins = 49 mins (expected answer)

ha ha ... I tried expanding column width tooo. its just ###

Where do you get 6 hrs 30 minutes for E4:E6 ?
E4 is 4 hrs
E5 is 2 hrs
E6 is Blank
SUM(E4:E6)= 6 hrs

=H4-SUM(E4:E6) formatted as time (hh:mm:ss), shows 1:19:00
EFskhari.xlsx

nope... still the same error.
Error starts when I add minutes next to the hours

E4 is 4.30 (four hours and thirty mins.)
E5 is 1.00 (One hour)
E6 is 1.15 (One hour and fifteen mins.)
SUM(E4:E6)=6.45 (Six hours and forty five mins.)

Total Hrs Logged is 7 hrs and 19 mins

TIME LEFT is 34 mins (15 mins +19mins) ANSWER

Please help!!!

It works in this format. thank you

You're welcome.