I am tracking paid time off in excel. We have been using a decimal fraction of a minutes like .5 fro 30 minutes. But since we started using quickbooks payroll, qbs used 30 minutes (1:30) for 1.5.
How do I convert my data from 1.5 to 1:30 in excel spreadsheet? Any idea?
Thanks.