All Questions
7
questions
0
votes
2
answers
139
views
Excel datetime format issue, possibly locale dependent
I'm working on a Belgian Excel 365 workbook. I have just imported a list of dates, looking like this:
dinsdag 5 december 2023 11:55:55
dinsdag 5 december 2023 11:55:56
dinsdag 5 december 2023 11:55:57
...
0
votes
2
answers
313
views
How to change a Generally formatted "20170824 08:45:58:544" into a Time formatted hh:mm:ss.ss?
The title is the gist of my problem. I've got a couple of thousand of these I need to convert into a hh:mm:ss.ss format while retaining (though not showing) the yyyymmdd converted to a mm/dd/yyyy ...
0
votes
1
answer
657
views
how to allow only specific format with data validation (hh:mm - hh:mm - shift scheduling)
so basically I need a formula which allows only data in the following format:
hh:mm - hh:mm (this is for shift scheduling, so e.g. 08:00 - 16:00)
Space before and after dash (-) is absolutely a ...
0
votes
1
answer
452
views
Exported duration times come up at time of day value in excel, any solutions?
I have the problem with a sheet I downloaded. Right now, online on its platform it displays the number correctly 0:31 (duration of a call) but when I export the list to excel for tracking, it comes up ...
0
votes
1
answer
64
views
Excel converts datetime to other format where days are low enough to be months
I live in europe and our datetime format is usually dd/MM/yyy
I have an excel spreadsheet where I have ALOT of dates
But for reasons I do not know, Excel converts where (dd < 12) to mm/dd/yyyy - ...
17
votes
1
answer
251k
views
How to concatenate a date in MS-excel and receive a date (not a number)
When I try to concatenate two cells in MS-excel in the formula I have the date as a integer number (eg: 04 april 2012 become 41006).
How can I display the date also in the formula cells?
0
votes
0
answers
330
views
In MS Excel cell format, How to change the default time duration from "number of days" to "number of minutes"?
In MS excel if I set a cell format as time (e.g. [h]:mm:ss) and then if I type any number N in that cell, MS excel assume that number as number of days since 1st Jan 1900 00:00:00. Is it possible to ...