| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using dates and time in formulas
I am substracting dates and times in 2 cells then using the sums to calculate percentages of loss and or gain. Do all my formula cells need to be in the same date and time format? ED -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=555737 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using dates and time in formulas
No, the format is irrelevant, the calculations will use the underlying
values. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "changetires" wrote in message ... I am substracting dates and times in 2 cells then using the sums to calculate percentages of loss and or gain. Do all my formula cells need to be in the same date and time format? ED -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=555737 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting time part of a Date, subtracting dates | Excel Discussion (Misc queries) | |||
| Continuous dates and time | Charts and Charting in Excel | |||
| calculate elapsed time between dates and times | Excel Worksheet Functions | |||
| Multiple dates, times, or formulas in a single cell | Excel Discussion (Misc queries) | |||
| How to create command button to save the dates and time | Excel Discussion (Misc queries) | |||
Linear Mode
