| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
expressing minutes negatively
I can figure out how to subtract one date/time from another, but the answer
is always expressed "positively". I am trying to express a negative value. In other words, I'm trying to show a difference (in hh,mm) of something being "early" by 15 minutes versus being "late" by 15 minutes. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
expressing minutes negatively
F1: <end time
F2: <start time As Excel shows negative times as ##### take largest from smallest and prefix by negative sign. =IF(F1<F2,TEXT(F2-F1,"-" & "hh:mm"),F1-F2) HTH "DJ" wrote: I can figure out how to subtract one date/time from another, but the answer is always expressed "positively". I am trying to express a negative value. In other words, I'm trying to show a difference (in hh,mm) of something being "early" by 15 minutes versus being "late" by 15 minutes. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
expressing minutes negatively
ToolsOptionsCalculation check Calendar since 1904
Format your result as [h]:mm:ss HTH -- AP "DJ" a écrit dans le message de ... I can figure out how to subtract one date/time from another, but the answer is always expressed "positively". I am trying to express a negative value. In other words, I'm trying to show a difference (in hh,mm) of something being "early" by 15 minutes versus being "late" by 15 minutes. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
expressing minutes negatively
Thanks! Perfect!
"Toppers" wrote: F1: <end time F2: <start time As Excel shows negative times as ##### take largest from smallest and prefix by negative sign. =IF(F1<F2,TEXT(F2-F1,"-" & "hh:mm"),F1-F2) HTH "DJ" wrote: I can figure out how to subtract one date/time from another, but the answer is always expressed "positively". I am trying to express a negative value. In other words, I'm trying to show a difference (in hh,mm) of something being "early" by 15 minutes versus being "late" by 15 minutes. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum increments of minutes and seconds | Excel Worksheet Functions | |||
| Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| AutoSave: How can I get it to save every 5 minutes & NO prompt? | Excel Worksheet Functions | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
Linear Mode
