HI,
I'm using the following to display the difference in time in minutes
=DateDiff("n",[timein],[timeout])
My question is how do i use it to display in either
decimal hours- 1.5 hours
hours and minutes - 1:30
for 1 hour 30 minutes
I'm using the following to display the difference in time in minutes
=DateDiff("n",[timein],[timeout])
My question is how do i use it to display in either
decimal hours- 1.5 hours
hours and minutes - 1:30
for 1 hour 30 minutes