| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time lapse to display in minutes
I'm trying to figure out the difference in time lapsed in just minutes
between an admit time and a visit time. For example Admit Time Lesion Cross Time Elapsed Time 8:21:00 9:55:00 1:34 I'm using =B2-A2 but I only want it to display the elapsed time in minutes. Help!! Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time lapse to display in minutes
Multiply the time difference by 1,440 (# minutes in a day) and format the
result as a number, not as time "Lynn" wrote: I'm trying to figure out the difference in time lapsed in just minutes between an admit time and a visit time. For example Admit Time Lesion Cross Time Elapsed Time 8:21:00 9:55:00 1:34 I'm using =B2-A2 but I only want it to display the elapsed time in minutes. Help!! Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time lapse to display in minutes
Thank you much! I did this but didn't format the cell as a number.
"Duke Carey" wrote: Multiply the time difference by 1,440 (# minutes in a day) and format the result as a number, not as time "Lynn" wrote: I'm trying to figure out the difference in time lapsed in just minutes between an admit time and a visit time. For example Admit Time Lesion Cross Time Elapsed Time 8:21:00 9:55:00 1:34 I'm using =B2-A2 but I only want it to display the elapsed time in minutes. Help!! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display hours, minutes, seconds on a time-scale axis in Excel 2003 | Charts and Charting in Excel | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| Time Lapse Calculation | Excel Worksheet Functions | |||
| Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
Linear Mode
