| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting time to a range of time
Is there any way to take a time in a spreadsheet and change it to a time
range? For instance, 13:45 would show as 13:01-14:00 or 2:25 would show as 2:01-3:00? -- Tasha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting time to a range of time
Tasha,
With the time of interest in cell A1: =TEXT(INT(A1*24)/24,"hh:mm") & "-" & TEXT(INT(A1*24+1)/24,"hh:mm") HTH, Bernie MS Excel MVP "sueshe" wrote in message ... Is there any way to take a time in a spreadsheet and change it to a time range? For instance, 13:45 would show as 13:01-14:00 or 2:25 would show as 2:01-3:00? -- Tasha |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting time to a range of time
=TEXT(TIME(HOUR(A1-1/24/60),1,0),"h:mm")&" -
"&TEXT(TIME(HOUR(A1-1/24/60)+1,0,0),"h:mm") Won't cope with an input of 00:00, but in general it's better to use 23:59 or 00:01. -- David Biddulph "sueshe" wrote in message ... Is there any way to take a time in a spreadsheet and change it to a time range? For instance, 13:45 would show as 13:01-14:00 or 2:25 would show as 2:01-3:00? -- Tasha |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting time to a range of time
That worked like a charm...thanks so much!!!!
-- Tasha "Bernie Deitrick" wrote: Tasha, With the time of interest in cell A1: =TEXT(INT(A1*24)/24,"hh:mm") & "-" & TEXT(INT(A1*24+1)/24,"hh:mm") HTH, Bernie MS Excel MVP "sueshe" wrote in message ... Is there any way to take a time in a spreadsheet and change it to a time range? For instance, 13:45 would show as 13:01-14:00 or 2:25 would show as 2:01-3:00? -- Tasha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
| Converting Eastern time to Central time | Excel Discussion (Misc queries) | |||
| Converting decimal time to standard time? | Excel Discussion (Misc queries) | |||
| Converting time | New Users to Excel | |||
| Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
Linear Mode
