0
votes
1answer
128 views

How to parse time expressions in shell?

I want to have a shell script with a parameter specifying some time. Is there already an existing way to transform time expressions ala: 1d, 34m, 3s, or 0.456h, or 23ms into lets say just ...
1
vote
2answers
1k views

Excel 2003: convert a numeric cell into time for calculations

I have some data in excel, all numeric, like: 9.00 10.35 19.10 I need to do calculations like: I got at work at 9.00, I got out at 10:00 = I've worked 1 hour How can I achieve this if all my ...
0
votes
1answer
635 views

Excel: Convert and replace time to seconds

I have a large number of cells that contain time duration in the form: 41m 9s How do I convert the duration into seconds, and then replace the old value of the cell with the converted value ? I ...
5
votes
4answers
5k views

Work with hours and minutes in Excel 2007

I'm working on a spreadsheet that holds phone calls durations. So, each call (row) has a value like 00:01:30, 01:02:12, etc. When I sum the duration column, it will give me something like 687:23:42. ...
5
votes
4answers
4k views

Timezone conversion by command line

I know about http://www.timeanddate.com/worldclock/converter.html I can't figure out how to query http://www.google.com in a sane natural format like "5pm BST in PST". Or do I have to write such an ...