date format

3 Topics

Date Formatting
I wonder if anyone could help me please? Its probably really simple but I can't for the life of me get Excel to do as I would like. On all our company graphs/pivots etc, date is displayed as 18/06 (yy/mm) I have tried using a custom format but it always defaults to a full date 01/06/2018 in the display bar even though displaying correctly in the data It causes havoc for my pivots. How can I have the column format my dates as YY/MM to display in the data and in the display bar? Please? Thank you Clair
Solved
Clair Huntley
Apr 30, 2019 Place Excel
3.7KViews
0likes
10Comments
Change date format
Hi all! I want to change a bunch of dates that look like the below into a simple 'Nov-16' format. How do I do this?
Edward Holden
Aug 14, 2018 Place Excel
1.3KViews
0likes
2Comments
Convert multiple combinations of date text strings into a seconds
Hi everyone! Maybe someone can help me with this problem... I'm using a software to manage telemarketing campaigns. This software allows me to create several informs and one of them is to know of much time an operator is logged in a campaign. The problem is that the output is in text format and with multiple combinations such as: - 2d19h20m55s - 4h58m56s - 15h37m5s - 21m55s - etc. My goal is to create a function that can convert all of this possible combinations in seconds. I started with this =+LEFT($C4;FIND("d";$C4;1)-1)*24*60*60 but now I'm stocked. Is it that possible or I have to create a function for any possible combination? Thanks in advance.
Solved
Daniel Martínez León
Aug 06, 2018 Place Excel
2.2KViews
0likes
3Comments