I have made the following formula to calculate the time difference
using the following formula ;
=INT(B2-A2)&" Days "&HOUR(MOD(B2-A2,1))&" Hour "&MINUTE(MOD(B2-A2,1))&"minutes"
It would be great if anyone of you could help me with VBA to add into a button so I could reset values in Cell A2 and Cell B2 ( if need, to add more cells too ) back to default date and time value such as "01/01/2021 00:00"
Further, in the above formula, if I want to change the calculate structure from Month-Date-Year to Date-Month-Year , what are the changes I should do to =INT(B2-A2)&" Days "&HOUR(MOD(B2-A2,1))&" Hour "&MINUTE(MOD(B2-A2,1))&"minutes" ?
Appreciate any of kind assistance.
using the following formula ;
=INT(B2-A2)&" Days "&HOUR(MOD(B2-A2,1))&" Hour "&MINUTE(MOD(B2-A2,1))&"minutes"
It would be great if anyone of you could help me with VBA to add into a button so I could reset values in Cell A2 and Cell B2 ( if need, to add more cells too ) back to default date and time value such as "01/01/2021 00:00"
Further, in the above formula, if I want to change the calculate structure from Month-Date-Year to Date-Month-Year , what are the changes I should do to =INT(B2-A2)&" Days "&HOUR(MOD(B2-A2,1))&" Hour "&MINUTE(MOD(B2-A2,1))&"minutes" ?
Appreciate any of kind assistance.
