LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default negative time input

I would like to be able to do is to input a negative. All of the previous
posts seem to show how to show the result of subtracting a large number of
hours from a smaller number - The 1904 format will give the negative answers
results.

I would like to be able to enter -ve times such as -1hr 24m in one of the
input cells in order total a row of times e.g.

A1 B1 C1
2:00 -1:24 = 0:34 =sum(a1:b1) etc
2:00 -3:13 = -1:13

is this possible?

Thanks in advance

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating time and negative time Josh UK Excel Worksheet Functions 3 February 8th 07 04:48 PM
calculation with hours and minutes - input of negative values MichaelMichael Excel Discussion (Misc queries) 2 July 10th 06 06:31 PM
Time Input Michael Excel Discussion (Misc queries) 5 February 10th 06 07:20 PM
Negative time should be allowed in Excel, eg time difference Bengt-Inge Larsson Excel Discussion (Misc queries) 2 October 13th 05 12:59 PM
can you input time (hh:mm:ss) without having to input the colon i. Lexicon Excel Discussion (Misc queries) 4 January 11th 05 02:09 PM


All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"