If A1 and B1 start and end times are 1:47 PM & 5:25 PM...and I want the answer in C1.
What is the formula that I would paste/enter in C1 that would give me 3:36?
Yes, that's 3 hours and 36 minutes. We do time cards based on 6 minute increments.
Thanks so much!!!
Welcome to the forum.
=B1-A1
Next time, please come up with a better title - one that tells us what you are trying to do 9see the forum rules).
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try
Format Cell>Time> 13:30Formula:
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
would this work for nearest 6 mins
=ROUNDDOWN((B1-A1)*240,0)/240
240 is the number of 6mins in a day
and i'm rounding down
so 13:47 will be 3:36 up until stop time reaches 17:29 , then its 3:42
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.
Assuming the times are real numbers and not text strings:
1) As AliGW says, a simple subtraction will calculate the difference between two time numbers.
2) An MROUND() function can then be used to round to the nearest 6 minutes. =MROUND(B1-A1,TIME(0,6,0))
If the times are text strings, then the first step is to convert them to real numbers or modify the data entry step to make sure that the times are entered as numbers.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks