Dear Experts please help, Answer should be in E2, I am using excel 2013... thanks in advanceClipboard02.jpg
Dear Experts please help, Answer should be in E2, I am using excel 2013... thanks in advanceClipboard02.jpg
Last edited by feroz763; 02-05-2018 at 02:40 AM.
Result of what? Difference of what?
If i enter time in a2 example 05:00 am result should be 02:30 am ( Two hour and thirty minutes difference )thank you all in advance.
What you need to understand about dates and times in excel is…
a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Sat 03 Feb 2018) is actually 43134
Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75
So to do what you want, use something like...
=A2-2.5/24
or
=A2-TIME(2,30,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It doesn't work: =A2-TIME(Two hour and thirty minutes)
@Ford,
It was joke
but first I should say this is Excel not a Word
Hi sir, This is what i am getting in excel 2013 - #VALUE!
when i enter this formulas =A2-2.5/24
or
=A2-TIME(2,30,0)
maybe use: =A2-TIME(2;30;0) (because of local settings)
Excel: 1.293
Word: one thousand two hundred and ninety-three
Guys please help.
Did you read post#9?
or
attach excel file with your problem
Clipboard02.jpg Answer should be in E2, I am using excel 2013... thanks in advance
this is not an Excel file
Pictures are useless. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.
To attach an Excel file to your post,
- desensitize data
- remeber that your example should reflect structure and type of data
- click Go Advanced,
- scroll down until you see Manage Attachments,
- click that and select Browse,
- select your file and click Open,
- click Upload and you will see your attachment below Upload Files from a website
- click Close this window,
- click Submit reply
After that you should see attachment in your post
If you tried any of the suggestions, and they didnt work, what was wrong?
If you didnt try them yet, then please do so.
Either way, post a sample workbook, not a pic, please
alternatively you can use PowerQuery (add-in for Ex2013)
Please Login or Register to view this content.
I have attached excel file please check... thanks
All the suggestions offered work however now you have introduced another column with the 2:30 in. Which is why posting your workbook to start with would have saved a lot of time
=A2+B2/24
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks