Is there a way that in column A <gs id="62195de4-04b9-4bea-b8ba-f70583f0ae6c" ginger_software_uiphraseguid="4ebdf7d3-69f4-47f7-855e-e71eef69fd54" class="GINGER_SOFTWARE_mark">i</gs> will enter the DATE (together with its format) and on column B is the TIME to be combined in column C (Date and Time; retaining its format)
The reason is that I am recording time <gs id="51e33b2b-2d20-4616-8327-133b6eaf9666" ginger_software_uiphraseguid="0d46bfe9-3ede-40a1-ac1f-47150e2a10e7" class="GINGER_SOFTWARE_mark">entries but</gs> it becomes <gs id="58fc9776-9eff-4229-977b-169e21b8835f" ginger_software_uiphraseguid="0d46bfe9-3ede-40a1-ac1f-47150e2a10e7" class="GINGER_SOFTWARE_mark">complicated especially</gs> if it will cross over to the next date
For example, my time in column A is 23:00 <gs id="37cb8917-8127-4d3c-acd2-7ac9bda394b4" ginger_software_uiphraseguid="dac90f1d-3536-4c45-be5c-922d3830f6b3" class="GINGER_SOFTWARE_mark">of</gs> April 30 and on column B is 05:00 <gs id="edf70dd9-f5b6-4148-af90-ad8589cba341" ginger_software_uiphraseguid="dac90f1d-3536-4c45-be5c-922d3830f6b3" class="GINGER_SOFTWARE_mark">of</gs> May 1. I need to get the total hours between column B - column A which will give me a large number if the date is not included
Or is there a better way to go around this.
Thanks in advance
Michael
The reason is that I am recording time <gs id="51e33b2b-2d20-4616-8327-133b6eaf9666" ginger_software_uiphraseguid="0d46bfe9-3ede-40a1-ac1f-47150e2a10e7" class="GINGER_SOFTWARE_mark">entries but</gs> it becomes <gs id="58fc9776-9eff-4229-977b-169e21b8835f" ginger_software_uiphraseguid="0d46bfe9-3ede-40a1-ac1f-47150e2a10e7" class="GINGER_SOFTWARE_mark">complicated especially</gs> if it will cross over to the next date
For example, my time in column A is 23:00 <gs id="37cb8917-8127-4d3c-acd2-7ac9bda394b4" ginger_software_uiphraseguid="dac90f1d-3536-4c45-be5c-922d3830f6b3" class="GINGER_SOFTWARE_mark">of</gs> April 30 and on column B is 05:00 <gs id="edf70dd9-f5b6-4148-af90-ad8589cba341" ginger_software_uiphraseguid="dac90f1d-3536-4c45-be5c-922d3830f6b3" class="GINGER_SOFTWARE_mark">of</gs> May 1. I need to get the total hours between column B - column A which will give me a large number if the date is not included
Or is there a better way to go around this.
Thanks in advance
Michael