Hi, I have a need to calculate the minutes between two date time cells as an integer number. To make matters a bit more tricky I need to only count minutes for a defined working day (cell with start day, cell with end day times).
My level of expertise in functions and macros is pretty limited so I am out of my depth at this point
Look forward to some clues as to what I need to do
I am now actually using excel 2010
Jmac1947
Last edited by jmac1947; 01-31-2012 at 12:05 AM.
upload a sample workbook with sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
samplesheet.xlsxsamplesheet.xlsxSorry, should have done that in the first place, hopefully attached now... comment in row 2 of the raw data tab attempts to explain
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks