|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
05-23-2006, 08:03 PM
|
|||
|
|||
Need help with time and date formula!!!
Please Help!!! How would you write a formula that adds the time between colums (military time) and a date that can change. If the date changes I want to add the time between changes EX:
DATE TIME ON/OFF Total Time 3/22/06 08:00 3/24/06 13.00 3/24/06 16:30 
|
|
#2
05-24-2006, 03:47 PM
|
|||
|
|||
|
Hi,
Do youwant this to show the time difference between each reading or only when the date changes? And do you want the changes to show from the last reading or from the first reading in that date? Do you want the difference in hours? Minutes? Days or a combination of all these? Regards Carl
|
|
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
