Ubuntu
openoffice.org package

Calculate time and dates in Spreadsheet

Asked by Yunkel

Hi,

I have a date and time in the spreadsheet and wish to add and subtract hours from the value in one cell. How can i do it

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Joker Wild (lajjr-deactivatedaccount) said : 		#1

write a little formula

highlight a box below say two times

click the equal sign type rowcolumn - rowcolumn

a1 1:30:00PM
a2 4:45:00PM
a3 =A1-A2

then you change the numbers all you want just don't changed the formula

Can you help with this problem?

Provide an answer of your own, or ask Yunkel for more information if necessary.

To post a message you must log in.