i am working on a excel spreadsheet inputting numbers that have been formatted to minutes in the format cell selection under time then i chose 13:33 for example using the semicolon however when i go to total those numbers i.e. 1:47 , :33, 6:78, :33 its not giving me the correct total for those entries i.e. 14:34 and the total is completely off. can someone help thanks
Can you upload an example worksheet (Go Advanced>Manage Attachments)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Try adding a column which multiplies the minutes cells by 24 and summing that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks