Hi,
I'm trying to do just a simple time elapse between two times =SUM(H3-G3) in time format, and the answer I'm getting is the correct minute length but adds 12 hours on too? I have tried doing =SUM((H3-G3)-12) but that hasn't worked, can anyone help?excel time difference.jpg
Change the custom formatting of your result cell to hh:mm:ss without the AM/PM bit.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
edit - ignore
if you change the format of all cells to general
what are the numbers
should be
i3
0.034722222
g3 & h3
0.335416667 0.370138889
otherwise formatting issue
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Tested here before posting suggestion in post #2 - same result as OP.
Ah that's sorted it thank you! I was sure it would be a simple thing it just wasn't coming to me at all!
Thank you so much for your help
You're welcome!
Let me make a comment on it
I shall confess that for me it was some time ago puzzling that 12:52 AM is just 52 minutes after midnight (in my simple logic it shall be 00:52 AM, but somehow in UK it is not written like that).
So indeed just 24h formatting as suggested by AliGW: "hh:mm:ss" will do the job.
And note for the possible future applications (or for instance for adding up such times, etc) if it is possible that a value will be greater than 24 hours, use:
"[hh]:mm:ss" format
Digging a bit more:
As for the formula, you probably can use justFormula:
Please Login or Register to view this content.
Or if it is just to be directly compared with column F, where you written 3/4 hour (0.75) then formula shall read:
and formatiing for this cell shall be generalFormula:Please Login or Register to view this content.
or may be:
to avoid problems when column H is still empty after filling column GFormula:Please Login or Register to view this content.
Last edited by Kaper; 08-01-2017 at 05:35 AM.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks