Hi all,
I'm having some trouble working out how to do this; I've searched everywhere but as of yet no results have given the level of detail I require.
I need to calculate the difference in hours/minutes/seconds between a given date in the format: "29/06/2015 - 13:57:12" and the "NOW"...
I have a query in which I'm converting number date "20150415" to "15-Apr-15" and then find the difference between 2 dates. first and last dates
I'm using the following expressions;
FLabour is a group by "Min" which is searching a Linked ODBC table.
Fdate...
Dear Great Minds of Excel,
I have the following data (Except column D)
Column A Column B Column C Column D Column E Column F Column G
Date 1 Start Time 1 End Time 2 Difference Start Date End Date Avg Time to Complete
01/01/14 08:00...
Hi,
I want to count the number of Wednesdays between 02-Apr-14 & 22-Oct-14.
If I have the first date in A1 and the second date in B1, does anyone know if it's possible to do this in a formula?
thanks,
Eoin
Hi
Im really stumped. Im trying to calculate the differences between 2 dates with variable hours for each day and round up out of hours times up to the next working time.
For example
Monday - Friday working hours are 07:00 to 18:00
Saturday working hours are 07:00 to 12:00
If a request...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.