LinkBack URL
About LinkBacks
how to calculate time?
Ex:
6:30am-3:30=??????
how to calculate time?
Ex:
6:30am-3:30=??????
I think everything normal calculation...
v A B C 1 Time Difference Result 2 6:30:00 AM 3:30:00 AM 3:00:00 AM 3 Formula --> =A2-B2
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I tried but it's not working.
I need 6:30am - 3 hours and 30 minute.
It looks like yours 6:30am is text
Try this
in B1
Formula:
Please Login or Register to view this content.
v A B 1 6:30am 03:00 AM
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
it is ok,
but i have pm also
6:30am -3:30 =??
12:00pm-3:30 =??
3:00pm-3:30=??
6:00pm-3:30=???
7:30pm-3:30=???
8:05pm-3:30=??
9:30pm-3:30=???
then use this
Formula:Please Login or Register to view this content.
v A B 1 6:30am 03:00 AM 2 12:00pm 08:30 AM 3 3:00pm 11:30 AM 4 7:30pm 04:00 PM
Last edited by AlKey; 12-01-2016 at 11:07 AM.
Yes it is OK. Thank you again.
6:30am -3:30Originally Posted by nnish
Is that all in a single cell or multiple cells?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
multiple cells
Let's assume this is your data:
Data Range
As is, Excel evaluates that as TEXT entries.
To convert them into true time values...
Select the range A1:A7
CTRL + H (that will open the Find/Replace userform)
Find what: am
Replace with: (press the spacebar)am
Replace All
Repeat the process for pm
The results should now appear as true time values like this:
Data Range
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks