Tags: calculating, enter, example, excel, microsoft, minus, msdn, negative, ports, secondary, software, table, tides, time, value

Time - Hours and Minutes

On Microsoft » Microsoft Excel

6,941 words with 4 Comments; publish: Thu, 22 May 2008 22:07:00 GMT; (30661.52, « »)

I need to enter negative time value (hour and minutes) in a table

calculating tides for secondary ports, for example 13:00 hours minus a

negative value such as 00:15 hours, i.e., 13:00 - (-00:15). Excell will not

allow negative time entry, is there any other way?

Appreciate your assistance

Regards

Mark Zak

All Comments

Leave a comment...

  • 4 Comments
    • Tools>options>calculation and 1904 date system will allow you to do

      calculations that return negative time. Note that all dates created earlier

      will have 1462 days added to them

      To convert back put 1462 in an empty cell, copy it, select the dates and do

      edit>paste special

      and select subtract

      --

      Regards,

      Peo Sjoblom

      "Mark Zak" <markzak.excel.todaysummary.com.barzak.com> wrote in message

      news:tkRQd.163830$K7.75893.excel.todaysummary.com.news-server.bigpond.net.au...

      >I need to enter negative time value (hour and minutes) in a table

      >calculating tides for secondary ports, for example 13:00 hours minus a

      >negative value such as 00:15 hours, i.e., 13:00 - (-00:15). Excell will

      >not allow negative time entry, is there any other way?

      > Appreciate your assistance

      > Regards

      > Mark Zak

      >

      #1; Thu, 22 May 2008 22:09:00 GMT
    • Appreciate your promt responce. I am still unable to enter negative values,

      for example negative hours:minutes (-00:15). I need to calculate time

      differences

      in relation to tide levels and need to input, say 13:00 (hours:minutes)

      minus

      negative value, say -00:15 (hours:minutes) to arrive at 12:45. Excel will

      not accept negative hours:minutes data entry

      Any thoughts ?

      Thanking in anticipation

      Mark Zak

      "Peo Sjoblom" <terre08.excel.todaysummary.com.mvps.org> wrote in message

      news:Ovt2vgIFFHA.2828.excel.todaysummary.com.TK2MSFTNGP09.phx.gbl...

      > Tools>options>calculation and 1904 date system will allow you to do

      > calculations that return negative time. Note that all dates created

      > earlier will have 1462 days added to them

      > To convert back put 1462 in an empty cell, copy it, select the dates and

      > do edit>paste special

      > and select subtract

      > --

      >

      > Regards,

      > Peo Sjoblom

      >

      > "Mark Zak" <markzak.excel.todaysummary.com.barzak.com> wrote in message

      > news:tkRQd.163830$K7.75893.excel.todaysummary.com.news-server.bigpond.net.au...

      >>I need to enter negative time value (hour and minutes) in a table

      >>calculating tides for secondary ports, for example 13:00 hours minus a

      >>negative value such as 00:15 hours, i.e., 13:00 - (-00:15). Excell will

      >>not allow negative time entry, is there any other way?

      >> Appreciate your assistance

      >> Regards

      >> Mark Zak

      >

      #2; Thu, 22 May 2008 22:10:00 GMT
    • You can overcome that entering by -15:00 like

      =-"15:00"

      and format as time, meaning that using 1904 date system will

      allow time displayed as negative while using windows default will not

      Regards,

      Peo Sjoblom

      "Mark Zak" <markzak.excel.todaysummary.com.barzak.com> wrote in message

      news:rJVQd.164060$K7.92895.excel.todaysummary.com.news-server.bigpond.net.au...

      > Appreciate your promt responce. I am still unable to enter negative

      > values,

      > for example negative hours:minutes (-00:15). I need to calculate time

      > differences

      > in relation to tide levels and need to input, say 13:00 (hours:minutes)

      > minus

      > negative value, say -00:15 (hours:minutes) to arrive at 12:45. Excel will

      > not accept negative hours:minutes data entry

      > Any thoughts ?

      > Thanking in anticipation

      > Mark Zak

      >

      > "Peo Sjoblom" <terre08.excel.todaysummary.com.mvps.org> wrote in message

      > news:Ovt2vgIFFHA.2828.excel.todaysummary.com.TK2MSFTNGP09.phx.gbl...

      >> Tools>options>calculation and 1904 date system will allow you to do

      >> calculations that return negative time. Note that all dates created

      >> earlier will have 1462 days added to them

      >> To convert back put 1462 in an empty cell, copy it, select the dates and

      >> do edit>paste special

      >> and select subtract

      >> --

      >>

      >> Regards,

      >> Peo Sjoblom

      >>

      >> "Mark Zak" <markzak.excel.todaysummary.com.barzak.com> wrote in message

      >> news:tkRQd.163830$K7.75893.excel.todaysummary.com.news-server.bigpond.net.au...

      >>I need to enter negative time value (hour and minutes) in a table

      >>calculating tides for secondary ports, for example 13:00 hours minus a

      >>negative value such as 00:15 hours, i.e., 13:00 - (-00:15). Excell will

      >>not allow negative time entry, is there any other way?

      >> Appreciate your assistance

      >> Regards

      >> Mark Zak

      >>

      >

      #3; Thu, 22 May 2008 22:11:00 GMT
    • Hi Peo,

      MANY THANKS, it works

      Kind regards

      Mark Zak

      "Peo Sjoblom" <terre08.excel.todaysummary.com.mvps.org> wrote in message

      news:%23yL%23xKVFFHA.3840.excel.todaysummary.com.tk2msftngp13.phx.gbl...

      > You can overcome that entering by -15:00 like

      > =-"15:00"

      > and format as time, meaning that using 1904 date system will

      > allow time displayed as negative while using windows default will not

      >

      >

      > --

      >

      > Regards,

      > Peo Sjoblom

      >

      > "Mark Zak" <markzak.excel.todaysummary.com.barzak.com> wrote in message

      > news:rJVQd.164060$K7.92895.excel.todaysummary.com.news-server.bigpond.net.au...

      >> Appreciate your promt responce. I am still unable to enter negative

      >> values,

      >> for example negative hours:minutes (-00:15). I need to calculate time

      >> differences

      >> in relation to tide levels and need to input, say 13:00 (hours:minutes)

      >> minus

      >> negative value, say -00:15 (hours:minutes) to arrive at 12:45. Excel will

      >> not accept negative hours:minutes data entry

      >> Any thoughts ?

      >> Thanking in anticipation

      >> Mark Zak

      >>

      >> "Peo Sjoblom" <terre08.excel.todaysummary.com.mvps.org> wrote in message

      >> news:Ovt2vgIFFHA.2828.excel.todaysummary.com.TK2MSFTNGP09.phx.gbl...

      >> Tools>options>calculation and 1904 date system will allow you to do

      >> calculations that return negative time. Note that all dates created

      >> earlier will have 1462 days added to them

      >> To convert back put 1462 in an empty cell, copy it, select the dates and

      >> do edit>paste special

      >> and select subtract

      >> --

      >>

      >> Regards,

      >> Peo Sjoblom

      >>

      >> "Mark Zak" <markzak.excel.todaysummary.com.barzak.com> wrote in message

      >> news:tkRQd.163830$K7.75893.excel.todaysummary.com.news-server.bigpond.net.au...

      >>I need to enter negative time value (hour and minutes) in a table

      >>calculating tides for secondary ports, for example 13:00 hours minus a

      >>negative value such as 00:15 hours, i.e., 13:00 - (-00:15). Excell will

      >>not allow negative time entry, is there any other way?

      >> Appreciate your assistance

      >> Regards

      >> Mark Zak

      >>

      >>

      >

      #4; Thu, 22 May 2008 22:12:00 GMT