I am trying to set up an excel spreadsheet with time from Quick books, however it is not converting correctly. I have changed to time in every possible way and it is still not giving me the correct conversion. Anyone have any helpful tips?
Thank you for the help, so Quick books has employee time saved as- .05 for 5 min and 1:00 for 1 hour, however this does not add the same in excel. Each way I have tried to format the cells still does not give me the total as quick books has. I need the 1 hour to be converted to 60 min not 1 hour for the time to add as quick books. Am I a little more clear? In the excel I posted the top group, Brandon, needs to add to 12:32, 12 hours and 32 min, I cant seem to get it there with out manually entering the converted time. I hope that helps clear up my needs, thank you again for the help!