I am importing a .csv file with two date columns. The date columns are formatted

Date & Time.

I need a formula that calculates the number of hours between the two date / time columns but doesn't take into account the minutes. All minutes weather .01 or .59 should be dropped from the formula calculation.

Two examples:

BegDate EndDate Hours

1/3/2018 8:01 1/13/2018 11:30 243

1/4/2018 8:01 1/15/18 18:15 274

Note: The Date / Time appear in the cells as military time but in the excel Formula bar as AM or PM. Thought you might need to know.

Thanks for any help.

Date & Time.

I need a formula that calculates the number of hours between the two date / time columns but doesn't take into account the minutes. All minutes weather .01 or .59 should be dropped from the formula calculation.

Two examples:

BegDate EndDate Hours

1/3/2018 8:01 1/13/2018 11:30 243

1/4/2018 8:01 1/15/18 18:15 274

Note: The Date / Time appear in the cells as military time but in the excel Formula bar as AM or PM. Thought you might need to know.

Thanks for any help.

Mark Sylvers

The two records below should both calculate to 100 hours but the first one does not.

BegDate EndDate Hours

01-13-2018 08:01 01-17-2018 12:00 99 (should be 100 hrs)

01-13-2018 08:01 01-17-2018 12:01 100

dwhawe, Champion

Formula Numeric Type named [Hours] = Floor(ToHours([Date Time Duration]))

To:

Formula Numeric Type named [Hours] = ToMinutes([Date Time Duration])/60

Mark Sylvers