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

Differences between a Timestamp

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


Joined: 31 Aug 2011
Posts: 6

PostPosted: Wed Aug 31, 2011 12:36 pm    Post subject: Differences between a Timestamp Reply with quote

I have read through the forums and I have seen the examples done, however, I am unable to get them to work.

All I want to do is to take:
Start Time End Time
20:58:37  21:00:47 

and display the difference between the two.

I have tried:

TIMEVALUE
TIME
MINUTES
SECONDS

I have no DATEDIFF option within the functions. I have tried to just use B1-A1 - notta.
If anyone has any information or can provide step by step details that would be great!
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Aug 31, 2011 12:39 pm    Post subject: Reply with quote

=B2-A2
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
LivinDeadGurl
General User
General User


Joined: 31 Aug 2011
Posts: 6

PostPosted: Wed Aug 31, 2011 12:47 pm    Post subject: Reply with quote

When I enter =B2-A2 I get #VALUE! displayed.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Aug 31, 2011 12:53 pm    Post subject: Reply with quote

You are trying to calculate with text values.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
LivinDeadGurl
General User
General User


Joined: 31 Aug 2011
Posts: 6

PostPosted: Sat Sep 03, 2011 6:29 am    Post subject: Reply with quote

The columns are formatted as time, so I am not sure what else to do to make them not text. I will keep playing with it and hopefully it works. Thanks for your help Wink
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Sep 03, 2011 7:22 am    Post subject: Reply with quote

No matter how you format your cells, a text is a text and a number is a number.
Get a new spreadsheet. Keep your hands off anything that is related to formatting (most people simply do not understand formatting).

Enter times in A1 and B1.
C1 =B1-A1

So simple.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
LivinDeadGurl
General User
General User


Joined: 31 Aug 2011
Posts: 6

PostPosted: Sat Sep 03, 2011 10:07 am    Post subject: Reply with quote

LOL Ok Ill let ya know how I make out. Thanks for your help Wink
Back to top
View user's profile Send private message
LivinDeadGurl
General User
General User


Joined: 31 Aug 2011
Posts: 6

PostPosted: Fri Sep 09, 2011 8:56 am    Post subject: Reply with quote

Thanks for all your help. I got it to work, but when I subtract its incorrect. Argh. Makes sense to me, but not sure why the computer doesnt think so.

A B

Row1: 20:51:40 19:56:20

Formula is b1-a1

It gives me a value of 23:04:40
Back to top
View user's profile Send private message
DiGro
Super User
Super User


Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

PostPosted: Fri Sep 09, 2011 9:12 am    Post subject: Reply with quote

Shouldn't it be
Code:
 =A1-B1
? Shocked

That gives me 00:55:20 which seems to be correct Laughing

LivinDeadGurl wrote:
It gives me a value of 23:04:40


Which is a matter of formatting as time.

The real value is -00:55:20 which is the difference from B1-A1, but negative time doesn't exists I presume Wink
_________________
DiGro

Windows 7 Home Premium and AOO 4.0.1 NL (Dutch)
Back to top
View user's profile Send private message
LivinDeadGurl
General User
General User


Joined: 31 Aug 2011
Posts: 6

PostPosted: Fri Sep 09, 2011 9:21 am    Post subject: Reply with quote

Yep you are right Wink I got it to format properly and it is currently working Wink

Thanks for your patience and assistance!!! Its greatly appreciated!
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