| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time to time range formula???
=TEXT(INT(C2*24)/24,"hh:mm") & "-" & TEXT(INT(C2*24+1)/24,"hh:mm")
is the formula I'm using. In my spreadsheet, column C lists the time the patient was discharged. I was given the formula above last year from a poster on an Excel website. I was looking at it today and I don't think it is allowing for those that show up as 7:00 for example. It displays 06:00-07:00 and 07:00-08:00. Which one is it going in? Is there a better formula that will put the times in the correct range? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting time to a range of time | Excel Discussion (Misc queries) | |||
| Convert time to time range | Excel Discussion (Misc queries) | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Threaded Mode
