LinkBack URL
About LinkBacks
Hi Guy's
Is there a way of calculating the column in green automatically
Thanks
Hi Guy's
Is there a way of calculating the column in green automatically
Thanks
Last edited by AliGW; 12-28-2020 at 04:06 AM.
Given the sample data, if the end time is less than the start time, just add 1 to the start date.
Ben Van Johnson
C3 and copied down:
=IF(B3="","",IF(E3<D3,B3+1,B3))
(If the End Time in Col E is earlier than the Start Time in Col D, it must be after Midnight, so Col C is date in Col B plus 1. Otherwise copy the date in Col B.)
Obviously this only works whilst the End Time is within twenty four hours of the Start Time.
If you want to include jobs that took more than a day you need a column to show that, so the formula can add that many days to Col B's date.
Ochimus
I for one, have no idea what MDT means and don't want to waste time looking it up, so in the future please use terms in your title everybody understands. Doing so might get you faster help as members tend to answer ( or no) based on the thread title. Thanks
Agree with Pepe, and have updated the thread title with my understanding of MDT in this context. Shorthand is rarely a good idea as an opening gambit.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Yippee!
Rare chance to beat Pepe and Ali has made my Christmas!
MDT is Mountain Daylight Time (seven hours behind the UK).
Although given we're on this Forum, it could have been the Microsoft Deployment Toolkit or even Multi-Disciplinary Teamwork (alright, that's a slight cheat)?
Ochimus
As the OP, like us, is in England, I am not sure about the time zone idea (but then I haven't opened the attachment) - why would a calculation need to 'span' a time zone?
EDIT: a quick look at the attachment suggests I'm right.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks