Not much to go on, Timbo. Are we talking 3.45 decimal, 3.45 hours, or 3.45 days? See Excel Dates & Times.
why not enter the times in the right format to begin with and write 3:45? this way xl will automatically assume it's a time. 8:65 however will not be recognized. That really does not make sense.
In formulae, depending on your locale, you might have to replace ; with , or vice versa.
hi Timbo,Originally Posted by Timbo
what you should do is correct the mistake yr colleague did before summing them up
try this formula to convert them to time
then you should be able to get the correct sum:
where A1 is the wrong entry.
There are currently 2 users browsing this thread. (0 members and 2 guests)