## IF Formula if Time is Greater than 10am

Hi, Here is my issue. In column “F3” I have a import time in the format 09:00. In column “T3” I’m trying to create a formula …

Hi, Here is my issue. In column “F3” I have a import time in the format 09:00. In column “T3” I’m trying to create a formula …

I am trying to create a spreadsheet which matches a Child’s date of birth to their school year. For example: Date of birth Year group 1 September 2008 to …

Hi Everyone, I am currently working on a spreadsheet for someone at work and require a little help as to how best format and organise the cells to minimise the …

I currently have a long table of data, in which i need to highlight the duplicates by colour but only in the last four weeks(rolling). I dont mind …

I have created individual annual leave worksheets with a pop out calendar for all employees, so now when I am inputing dates in to individual worksheets I …

I’m working on a sheet that has a calculated date (i.e., condition met, date +/- days = result). I don’t need the day field, but do need to …

Hi – hope you can help. I have a spreadsheet with the following columns a) Qualified b) Finished c) Length of Partnership (there are other columns but …

Hello, in A1 I have a date and time shown as 201008061730 (yyyymmddhhmm). How do I get the date element into B1 as 06/08/2010 and in C1 the time as 17:30? …

The DATEDIF function in Excel will calculate the difference between two dates, showing you the answer in days, months, or years depending on how you specify it …

Hi no matter how I format the dates in Excel when i perform various date calculations to work out the number of days between dates it counts them as US

Microsoft Excel’s WEEKNUM Function returns a number that indicates where that particular week falls numerically within a year. The format for this …

Excel has a built in function that will calculate the month of a specified date and return the integer value for that month. For example 14 Jan 10 will return …

Sometimes it is useful to calculate the amount of days between two dates. But an even more useful tool is to be able to calculate the number of working days …

Excel has an inbuilt function that allows you to work out the number of working days between two dates. In fact, it is just as simple as working out the total …

Have you ever needed to show the current date and time combined into one cell? Simple solution is to click into the cell you want it displayed and type …

Sometimes it is required to always have the current date displayed on a workskeet whenever you open it. A very quick and easy method is to type =TODAY() in a …

Sometimes when you receive data in an Excel file that has been downloaded from a database the date and time are in the same column together (as shown in column …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.