Easy One - Multiply hours per day by days.

[garypea123]

Hi, I am trying to write formula which will give me the result of 37.5 hours in G3

My Formula which is incorrect shows =(I3-H3-J3)*K3

Obviously the K3 but is not correct or I need to amend the formatting some how.

 

[FormR]

Hi, if you want the value returned to remain as a time then use a custom format of [hh]:mm for cell G3

 

[garypea123]

Hi, if you want the value returned to remain as a time then use a custom format of [hh]:mm for cell G3

Works a dream

I had format as hh:mm, may I ask the difference between that and [hh]:mm

 

[FormR]

may I ask the difference between that and [hh]:mm

hh:mm will only return the hour and minute portion of the date/time and as your calculation returned a time greater than a day, the actual date/time it returned was 1st January 1900 13:30.

Using the square brackets tells excel to display the total elapsed hours instead.

 

[garypea123]

Thats perfect - Fully understood.

Thank you