[libreoffice-users] Re: Inconveniences of time format

Am 31.10.2015 um 08:40 schrieb Gary Collins:
> Hi
>
>
> I've got a column in calc 4.3.2.2 to contain the length of video clips; it's formatted to 
> Time>876613:37:46. 
>   
>
> The first inconvenience is that, when using autoincrement the times are incremented not by 1 
> second but by 24 hours. 
>  
>
> Whilst i understand that this is due to the way date/time is stored, with the date as integer and 
> the time as fraction, i think it is not exactly intuitive. I feel that it might be much more 
> convenient if LO would take the formatting into account and increment by 1 second (or, to be more 
> precise, by 1 LSD  to the chosen format).
>
>
> Similarly, when entering such times i think it would be more helpful to give precedence to the 
> LSD, so entering 8, for example, would be interpreted as 8 seconds (rather than 8 hours as is 
> cuŕrently the case) and 8:40 as 8m40s. Again, this interpretation should be format dependent.
>  
>
> What does anyone else think?
>
>
> Best
>  
>  
> /Gary

Fill down =A1+1/86400 (with A1 being the start time)



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted