Not sure if you want to just display the value as number as a message B12 contains the later date - earlier date
=INT(B12/(60))&" Hours "&INT(MOD(B12+0.0001,60))&" Minutes" Creates This 48 Hours 50 Minutes Had to add the 0.0001 otherwise was showing 49 minutes when int used. On 24 Apr 2015 at 3:49, sserra wrote: Date sent: Fri, 24 Apr 2015 03:49:06 -0700 (MST) From: sserra <[email protected]> To: [email protected] Subject: [libreoffice-users] Re: time and date difference > hello, > wonderful, the solution Michael D. Setzer II gave is amazing! Many thanks! > > > > -- > View this message in context: > http://nabble.documentfoundation.org/time-and-date-difference-tp4147099p4147109.html > Sent from the Users mailing list archive at Nabble.com. > > -- > To unsubscribe e-mail to: [email protected] > 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 > +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:[email protected] mailto:[email protected] http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +----------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 28512493.011262 | SETI 50011275.211265 ABC 16613838.513356 | EINSTEIN 58725353.615700 -- To unsubscribe e-mail to: [email protected] 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
