Using Time Formulas

[GoGoeGo]

I'm trying to calculate a formula that will allow me to view additional time on site if it exceeds 2 hours. Please use the examples I've provided.Time Formula Examples.xlsx

[mcmahobt]

Is column C in hours?

[etaf]

you need to use
=D2-C2
so that you get a time and not #################
=IF(E2<=F2,"","value of what")

what value are you wanting to return
also you need to enter 2hours into F2 - you can change theformat of the cell to display as required

but you need to be in times AND not numbers

[GoGoeGo]

ETAF -
The value of additional time on site. So if E2 is greater than F2, I would like to see by how much. In the example, the value should be 2 hours additional.

[etaf]

this should do it
=IF(E4<=F4,"",E4-F4)

but you need the formats correct
try using HH:MM:SS

[Vikas_Gautam]

Hi GoGoe...
Is this what you were trying to achieve..?
Check the attached file...

[GoGoeGo]

Time Formula Examples.xlsx

None of these seem to be working for me. Please see the newly attached sheet with more information.

[etaf]

whats wrong with row 5 in your last example ?

[GoGoeGo]

Nothing, that's what it should look like, but I can't get the formulas to work and return a time in cell G5. I keep getting #####.

[etaf]

its your formatting
they all have to be in time format
and cant be in numbers
you are taken times away

Dates are just numbers
1 day - 1
and the time is a fraction of a day
so 6 hours is a 1/4 of a day 0.25
12 hours 1/2 a day 0.5

so in E5
=D5-C5
and you can format as Hours
HH:MM

in F5 you need the time as a decimalfor 2 hours
OR
format the cell as time

OR you can do as

Vikas_Gautam has done and multiplied by 24
and also used ABS to do that the sign - or +ve does not matter

whats wrong with Vikas_Gautam solution ?
with the calculation I put - to show the difference

E?-F?