MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
Hi Guys,
I havent posted on here for many years
Im using Office 2010
I have a spreadsheet which i need to calculate the time between but i cannot for the life of me remember how to do this so i wonder if someone could kindly point me in the right direction
In Column B (EG B2) i have this data "2017-09-01 09:00:00 +0100" I need to extract the time only (09:00:00) to go in C2
In Coumn D (EG D2) I have this date "2017-09-01 11:00:00 +0100" i need to extract the time only (11:00:00) to go in E2
Then what i need to do is calculate the difference (EG E2-C2) to go in time in cell F2 and copy down the page
Any help greatly appreciated as this is driving me mad
Many thanks
I havent posted on here for many years
Im using Office 2010
I have a spreadsheet which i need to calculate the time between but i cannot for the life of me remember how to do this so i wonder if someone could kindly point me in the right direction
In Column B (EG B2) i have this data "2017-09-01 09:00:00 +0100" I need to extract the time only (09:00:00) to go in C2
In Coumn D (EG D2) I have this date "2017-09-01 11:00:00 +0100" i need to extract the time only (11:00:00) to go in E2
Then what i need to do is calculate the difference (EG E2-C2) to go in time in cell F2 and copy down the page
Any help greatly appreciated as this is driving me mad
Many thanks