|
May 2019
2:13pm, 22 May 2019
27,919 posts
|
SPR
Does it give an answer or error?
|
|
May 2019
2:17pm, 22 May 2019
38 posts
|
Neal
LibreOffice has no problems with Min of a range in hh:mm:ss format for me.
|
|
May 2019
2:25pm, 22 May 2019
317 posts
|
Sam Jelfs
can you not just format the cells as numbers and take the min of that?
|
|
May 2019
2:40pm, 22 May 2019
40 posts
|
Neal
hh:mm:ss format is a number, so you can reformat 12:00:00 and it can appear as 50% or 0.5 or £0.50.
Problems tend to arise when people end up with text that looks the same as a time formatted number or when they have times over 24 hours.
|
|
May 2019
2:55pm, 22 May 2019
318 posts
|
Sam Jelfs
if it is text rather than a numeric value then TIMEVALUE should handle the conversion for you.
|
|
May 2019
3:07pm, 22 May 2019
31,482 posts
|
HappyG(rrr)
What's the cheapest way to buy MS Excel for home use? I've tried Libre Office with its free spreadsheet but have discovered that I'm too used to MS Excel (I couldn't group dates into months and years in a pivot table in LO!)
I've got MS Windows 10 and I thought it had office but it was just a trial version and it's run out now. Thanks  G
|
|
May 2019
3:12pm, 22 May 2019
42,546 posts
|
GlennR
I use the Office 365 subscription service myself Happy G. £7.99 per month.
|
|
May 2019
3:13pm, 22 May 2019
31,483 posts
|
HappyG(rrr)
Bit rich for me Glenners. I'm allergic to paying MS anything, and certainly not £500 over the 5 years I expect to have the laptop!
Looks like Office 365 Home is £64. But Ive seen a dodgy add for Office 2016 for £35 with warnings to "uninstall Office 365 first". Does that sound legit? G
|
|
May 2019
3:15pm, 22 May 2019
42,548 posts
|
GlennR
Possibly not. I like the sub because I always have the latest versions plus lots of cloud storage space.
|
|
May 2019
3:18pm, 22 May 2019
1,106 posts
|
oumaumau
spr : it gave 00:00:00 even when all cells had numbers, but looking at the values in the time cells there was an pre-pended ' - remove that and it works
HG : I think office may now be subscription only - it certainly is going forward . No good for me using it once in a blue moon.
|
