Help....
I'm looking for a formula or macro to help me with some conversions.
I am working with data from a pressure recorder that records the data in minutes once the battery is hooked up. This results in having several days worth of data being recorded based on minutes elapsed since being turned on.
I need to convert this string of cumulative minutes to a date, hour, minute figure from a designated date, hour, minute start time.
any help????
thanx
jeff
Hi Jeff and welcome to the forum.
With your start date/time in A1 which is named 'start' and the minutes in C1 use
format C1 as dd:mm:yyyy - hh:mm
Please Login or Register to view this content.
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanx Richard;
the string works great ..... and it's so simple. Can't think why I didn't think of it that way myself
jeff
Last edited by shg; 09-01-2010 at 08:41 AM. Reason: deleted spurious quote
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks