Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time from Text
We have a program at work that exports a text field from rotas as 1900-0700 or any variation of. I need to convert this into hours difference and also run across midnight. I've tried "=Right(A1,4)-Left(A1,4)", which gets me partially the way there, but not managed to progress beyond the very basics. I've played with the TIME function to no avail, i managed to achieve what i wanted over nine columns but that is ludicrous, any pointers, flashes of inspiration would be much appreciated. I'm prepared to put this into VBA later, but would rather have it as a calculation on the sheet -- Maurice ------------------------------------------------------------------------ Maurice's Profile: http://www.excelforum.com/member.php...fo&userid=1948 View this thread: http://www.excelforum.com/showthread...hreadid=374055 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time from Text | Excel Discussion (Misc queries) | |||
Keep number format after converting time to text | Excel Discussion (Misc queries) | |||
Convert Text Time to Time | Excel Discussion (Misc queries) | |||
problem working with time data imported from text file | Excel Worksheet Functions | |||
Time calculations & text conversions | Excel Discussion (Misc queries) |