| View previous topic :: View next topic |
| Author |
Message |
LivinDeadGurl
General User
Joined: 31 Aug 2011
Posts: 6
|
 Posted: Wed Aug 31, 2011 12:36 pm Post subject: Differences between a Timestamp |
 |
|
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 |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed Aug 31, 2011 12:39 pm Post subject: |
|
|
=B2-A2
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
LivinDeadGurl
General User
Joined: 31 Aug 2011
Posts: 6
|
| Posted: Wed Aug 31, 2011 12:47 pm Post subject: |
|
|
| When I enter =B2-A2 I get #VALUE! displayed. |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed Aug 31, 2011 12:53 pm Post subject: |
|
|
You are trying to calculate with text values.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
LivinDeadGurl
General User
Joined: 31 Aug 2011
Posts: 6
|
| Posted: Sat Sep 03, 2011 6:29 am Post subject: |
|
|
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  |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sat Sep 03, 2011 7:22 am Post subject: |
|
|
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 http://forum.openoffice.org |
|
| Back to top |
|
|
LivinDeadGurl
General User
Joined: 31 Aug 2011
Posts: 6
|
| Posted: Sat Sep 03, 2011 10:07 am Post subject: |
|
|
| LOL Ok Ill let ya know how I make out. Thanks for your help |
|
| Back to top |
|
|
LivinDeadGurl
General User
Joined: 31 Aug 2011
Posts: 6
|
| Posted: Fri Sep 09, 2011 8:56 am Post subject: |
|
|
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 |
|
|
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1209
Location: Hoorn NH, The Netherlands
|
| Posted: Fri Sep 09, 2011 9:12 am Post subject: |
|
|
Shouldn't it be ? 
That gives me 00:55:20 which seems to be correct 
| 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
_________________
DiGro
Windows 7 Home Premium and OOo 3.3 NL (Dutch) |
|
| Back to top |
|
|
LivinDeadGurl
General User
Joined: 31 Aug 2011
Posts: 6
|
| Posted: Fri Sep 09, 2011 9:21 am Post subject: |
|
|
Yep you are right I got it to format properly and it is currently working
Thanks for your patience and assistance!!! Its greatly appreciated! |
|
| Back to top |
|
|
|
