Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
This is what I have in range B1:B7
12:00AM 12:30AM 1:00AM 1:30AM 2:00AM 2:30AM 3:00AM I want to convert these times into (IST +9:30) and put them in A1:a7 Sheshadri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Time - converting HH:MM:SS to Minutes | Excel Worksheet Functions | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
Converting time to numbers | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |