Time values

[Ken]

Could someone please help. I am trying to do something
with excel and I do not have a clue how to do it. Here is
what I would like to do

If I enter in column A, a start time and in column B a
finish time, how do I get column C to add the hours. Then
in the next column read 0 if there is a value and 1 if
there is not.

Thanks
Ken

 

[JulieD]

Hi Ken

in C1
either
=B1-A1+(B1<A1)
or
=MOD(B1-A1,1)
- both formulas deal with the possiblity of B1 being after midnight. You
can then format the cell as a [H]:MM format to display the result in a time
formula or multiply the formulas by 24 to give a number of hours

in D1
=IF(C1<>0,1,0)

Hope this helps
Cheers
JulieD

 

[Guest]

Thanks Julie that worked great

-----Original Message-----
Hi Ken

in C1
either
=B1-A1+(B1<A1)
or
=MOD(B1-A1,1)
- both formulas deal with the possiblity of B1 being after midnight. You
can then format the cell as a [H]:MM format to display the result in a time
formula or multiply the formulas by 24 to give a number of hours

in D1
=IF(C1<>0,1,0)

Hope this helps
Cheers
JulieD

Could someone please help. I am trying to do something
with excel and I do not have a clue how to do it. Here is
what I would like to do

If I enter in column A, a start time and in column B a
finish time, how do I get column C to add the hours. Then
in the next column read 0 if there is a value and 1 if
there is not.

Thanks
Ken

.

 

[JulieD]

you're welcome - thanks for the feedback

Thanks Julie that worked great

-----Original Message-----
Hi Ken

in C1
either
=B1-A1+(B1<A1)
or
=MOD(B1-A1,1)
- both formulas deal with the possiblity of B1 being after midnight. You
can then format the cell as a [H]:MM format to display the result in a time
formula or multiply the formulas by 24 to give a number of hours

in D1
=IF(C1<>0,1,0)

Hope this helps
Cheers
JulieD

Could someone please help. I am trying to do something
with excel and I do not have a clue how to do it. Here is
what I would like to do

If I enter in column A, a start time and in column B a
finish time, how do I get column C to add the hours. Then
in the next column read 0 if there is a value and 1 if
there is not.

Thanks
Ken

.