OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Difference between 2 dates

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
moncostarica
General User
General User


Joined: 08 Mar 2012
Posts: 5

PostPosted: Wed Jun 13, 2012 11:35 am    Post subject: Difference between 2 dates Reply with quote

Hello,

Is there any macro to compute the difference between 2 dates including the hours.

I mean : 12/3/2012 10:00 - 14/3/2012 18:00 = 3 days (2 days + 8 hours)

Thank you,
franck
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Wed Jun 13, 2012 11:56 am    Post subject: Reply with quote

Hello

Maybe this helps you
http://www.oooforum.org/forum/viewtopic.phtml?t=134933&highlight=hours

Romke
_________________
OOo 3.4.5 on openSUSE 12.1
Use this forum : http://user.services.openoffice.org/en/forum
Back to top
View user's profile Send private message
moncostarica
General User
General User


Joined: 08 Mar 2012
Posts: 5

PostPosted: Wed Jun 13, 2012 1:18 pm    Post subject: Thanks / SOLVED Reply with quote

Yes, thanks I can fix it easily

D1
D2
ARRONDI.SUP(D2-D1) o ROUND in English I guess

Thanks.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group