| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
find the difference between start time and end time when spann
How would I format the fields so excel would know when I entered 3:00AM- it
was Sunday, when the job was started on Friday at 10PM? "Mike H" wrote: You can't just say 10:00 PM Friday 3:00 AM Sun you need a date and a time and then it's simply =b1-a1 where B1 is the later date/time format the answer as [hh]:mm Mike "wahoos" wrote: I'm trying to find the difference between start time and end time when the total time will exceed a 24 hour period. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show time difference between start and end times | Excel Discussion (Misc queries) | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| how to find time difference between timestamps to a millisecond? | New Users to Excel | |||
| Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
| How do you find the difference between two time values when one i. | Excel Discussion (Misc queries) | |||
Threaded Mode
