Hi i am looking for a formula to Add up between two times what the difference is in minutes.
Hopefully someone can help ?
Lee
Hi i am looking for a formula to Add up between two times what the difference is in minutes.
Hopefully someone can help ?
Lee
Just to confirm, you have two times and you want to know how many minutes between them?
ie 10:00:00 and 11:15:00 would return 75
and it needs to be in minutes?
if so then format your answer cell as a number and use the following formula (assuming A1 and A2 hold your times)
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
Thanks Just what i as looking for!! would you know how to add two separate dates to this formula if it goes over one day?
You would use the same formula if dates were included with the time. If there are no dates but it might cross midnight, try
=MOD(A2-A1, 1) * 24 * 60
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
Thats brilliant! my times sometimes cross midnight but dont ever go over more then one day. To think i have been working out these times by hand for months! thank you for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks