combining DATE and TIME in a single

[maeyks]

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

 

[mole999]

in c8 =A8+B8 and format for dd/mmm/yy hh:mm

for a quick way of putting the current date in a cell use CTRL + ; , the current time if it helps can be entered with CTRL SHFT :

 

[maeyks]

in c8 =A8+B8 and format for dd/mmm/yy hh:mm

for a quick way of putting the current date in a cell use CTRL + ; , the current time if it helps can be entered with CTRL SHFT :

Thank you very much for this!

 

[FDibbins]

What you need to understand about dates and times in excel is…

a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Mon 01 May 2017) is actually 42856

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

So all you really need to do - as mole showed you - is just add them together and format (also, like he showed)

 

[maeyks]

What you need to understand about dates and times in excel is…

a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Mon 01 May 2017) is actually 42856

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

So all you really need to do - as mole showed you - is just add them together and format (also, like he showed)

Thiswasveryhelpful

 

[FDibbins]

Happy to help