Have separate Date and Time values - How to make a DATE/TIME value

I have a field for Date and a field for time - but I need a DateTime value so I can do calculations to get Length of Stay resulting in Hours.

How do I do this?

Do I concat the two fields or is there a function for this?

Date example:

Date Time

Preparation

Accepted answers

Here is an alternative version.

Thanks,

Mark

Hey there!

There are probably a bunch of different ways to do this but this is a pretty basic concat then reformat. Hope this does what you need!

Jack

Here is an alternative version.

Thanks,

Mark

MarqueeCrew - Sincere Thanks!

Your example just showed me how to use Formula better.