Net duration between 2 dates AND times

Hi folks, 

Ok, this is a tricky one:

I'm trying to set something that was requested by many people on this community forum - a NETWORKDAYS that can account for TIME as well. In other words, the amount of working days/hours between to periods (that accounts for.

There is this amazing site: https://www.exceltactics.com/calculate-net-work-hours-using-networkdays/

=IF(OR($End_Time<$Start_Time,End_Date<Start_Date),0,

        (NETWORKDAYS(Start_Date,End_Date,HolidayList)

        -(NETWORKDAYS(Start_Date,Start_Date,HolidayList)

        *IF(MOD(Start_Date,1)>$End_Time,1,

                (MAX($Start_Time,MOD(Start_Date,1))-$Start_Time)

                /($End_Time-$Start_Time)))

        -(NETWORKDAYS(End_Date,End_Date,HolidayList)

        *IF(MOD(End_Date,1)<$Start_Time,1,

                ($End_Time-MIN($End_Time,MOD(End_Date,1)))

                /($End_Time-$Start_Time))))

        *($End_Time-$Start_Time)*24)

 Problem 1) There is no MOD fonctions in smartsheet, but there is a workaround when you think about it (@Craig, you are my star on this forum, it's always good stuff) that can be found here : https://community.smartsheet.com/discussion/can-smartsheet-perform-mod-function

So (this is from Craig) :

 =MOD(F3,64)*4    = 160 

can be converted to this

=(F3 - (64 * INT(F3/64))) * 4

The Modulus MOD(A,N) is:

=A - (N * INT(A/N))

and then in your example you multiply by 4

but...

Problem 2) How do I get around the START_DATE / END_DATE that, in excel, includes the DATE AND the TIME? As far as I know, there is no way to do that in smartsheet. You need to columns for each (one being the date and one being the time). So is there a NETWORKHOURS type of option we can write?

Anyone? Anyone? Bueller?