It's really going to depend on what you want to do with them (the differences).
Excel stores "time" as a number that represents the fractional part of a day.
That means that at 6:00am, 6/24 of the day has passed, so Excel stores the
value as .25at 9:36am, .4 of the day has passed.and so forth.
So, even thought the VALUE in the cells is a number, Excel lets you DISPLAY it
in any manner you wish. 9:36:00 AM, or even a "custom" format:"hh.mm.ss"
results in: 9.36.00But the VALUE (.4000) remains the same.
So, since these are numbers, you can subtract the two numbers:G2-E2 is:10:54 -
9:36 which is:0.454166666666667 - .4000000 which equals:0.054166666666667 which
can be shown as:1:18
to expand this a bit:Excel DATES are numbers too.They're the number of days
since 1/1/1900.so, August 24, 2015 is 42240So that means that August 24,2015 at
9:36am is 42240.4
that means that you can subtract two date/times and get the number of days and
the fractional part of days between two times that are on different dates.
hope this helps.
Paul-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
From: Avinash Singh <avikrsing...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Thursday, September 10, 2015 3:09 AM
Subject: $$Excel-Macros$$ Timing calculation
Dear Concern,
Please find the attached excel file and get me solution regarding difference
between timing.
Thanks.--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
