Thanks for the clip. I would like to convert minutes to hours and Minuets say I have the number 70 in a cell I would like to convert it to show 1Hr 10 Mins
@doug h great Video. I have one thing to ask. I also have to calculate the total hours within the working hours. exp. my start date is 19/4/2019 10:00am and end date is 26/4/2019 7:00 pm and working hours are start 9:00 am and end is 8:00 pm everyday (excluding Sunday). how do I calculate the total time in days hours and minutes. Thanks in advance
Might need to incorporate some of the concepts here with the workday or networkday functions. See some of these videos for insight ua-cam.com/users/dough517search?view_as=subscriber&query=workday
I wanted to know how to input time log including the seconds. CTRL + SHIFT + COLON only input time in hours and minutes the seconds are always logged as 00. I wanted to compute elapse time in seconds. Anybody can help?
I Want to convert EST/EDT time to IST time the answer is come time with AM/PM (or) another type is date with time but i want answer like this in IST time 14/06/2020 8:32:47 AM or PM any one can help from this
Hi Doug, thank you for your video. I would like to understand more, as i doing a catalogue of videos, am required to log the video time duration. How do i record timings such as 55:35 in a single cell? Appreciate your advice. Thank you.
Thanks for the video....can we have date format in dd-mm-yy format followed by the time ? Or the excel can only take the system date format to calculate ?
Try using the MID function to break it out first (ua-cam.com/video/SeKdzEh86IM/v-deo.html) to see if it is "readable" as a date/time in excel. You may see if DATEVALUE can convert too (ua-cam.com/video/OZ1YpRJ_txY/v-deo.html)
You just saved me so much time with a spreadsheet I am working on for work. Thanks!
Thanks for the clip. I would like to convert minutes to hours and Minuets say I have the number 70 in a cell I would like to convert it to show 1Hr 10 Mins
thank you for the precise explaination
thank you so much. saved me a lot of time.
Very Helpful. Appreciate if you could give a link to download practice file to follow along.
Hi Rajeev Gosavi, thanks for the comment, sorry don't have files to download :-(
Simple and neat explanation ! thanks Chief .
Thank You Doug 👍👍👍👍
You’re welcome!!
Helpful
Thanks!!
Thank You Doug
thanks
You're welcome!
brilliant, thanks
You're welcome!
how to calculate the time in and time out then convert hours to no of days work?
@doug h great Video. I have one thing to ask. I also have to calculate the total hours within the working hours. exp. my start date is 19/4/2019 10:00am and end date is 26/4/2019 7:00 pm and working hours are start 9:00 am and end is 8:00 pm everyday (excluding Sunday). how do I calculate the total time in days hours and minutes. Thanks in advance
Might need to incorporate some of the concepts here with the workday or networkday functions. See some of these videos for insight
ua-cam.com/users/dough517search?view_as=subscriber&query=workday
Thank you.
You're Welcome!
hello, can you show me how to convert weeks number in date if i now the day ?
I wanted to know how to input time log including the seconds. CTRL + SHIFT + COLON only input time in hours and minutes the seconds are always logged as 00. I wanted to compute elapse time in seconds. Anybody can help?
One of these playlist vids might help ua-cam.com/video/Y9rlqOQBNQI/v-deo.html
Hi i was wondering can you help me design something where i can convert days to hrs to mins and to sec in a spread sheet. thanks
Thank you for your help
Thanks Jonathan C, glad it helped!
excellent information very useful
Hi sai ram, thanks for the comment!
What if u run a business and the clock starts at 9am and ends at 5pm. Plus any public holidays and weekend not to be included
The playlist might have some videos to pick out for your situation and give insights.
ua-cam.com/video/Y9rlqOQBNQI/v-deo.html
I Want to convert EST/EDT time to IST time the answer is come time with AM/PM (or) another type is date with time but i want answer like this in IST time 14/06/2020 8:32:47 AM or PM any one can help from this
Hi vijayakumar D, try to post on the mrexcel.com forum!
Hi Doug, thank you for your video. I would like to understand more, as i doing a catalogue of videos, am required to log the video time duration. How do i record timings such as 55:35 in a single cell? Appreciate your advice. Thank you.
maybe this video will give insight
ua-cam.com/video/wIuFloJRhdI/v-deo.html
Thankyou thankyou very very much 💋💋💋💋💋💋
Hi +xhiin Paii, glad you liked it, thanks for commenting!
Thanks for the video....can we have date format in dd-mm-yy format followed by the time ? Or the excel can only take the system date format to calculate ?
Yes, it can be display differently in the format cells dialog box. A related video will give some insight =>ua-cam.com/video/wIuFloJRhdI/v-deo.html
THANK YOU!!! :D
Hi Lykke Breum Madsen, you're welcome!
How will make 410 days convert to 1years 1months 15 days in Microsoft Excel
Use the DATEDIF function. For insight see ua-cam.com/video/Y9rlqOQBNQI/v-deo.html
great!
Hi OTHER, thanks for the comment!
please help me sir how to convert 12 hour to 24 hour by formula
Maybe this videos can give some insight
ua-cam.com/video/wIuFloJRhdI/v-deo.html
ua-cam.com/video/868p4QL4xRQ/v-deo.html
I have date in 20170201001833 "yyyymmddhhmmss" and unable to convert into date format please help
Try using the MID function to break it out first (ua-cam.com/video/SeKdzEh86IM/v-deo.html) to see if it is "readable" as a date/time in excel. You may see if DATEVALUE can convert too (ua-cam.com/video/OZ1YpRJ_txY/v-deo.html)
lm interested in B/B only pleasen
Sorry, don’t understand the comment/ question...
How to convert 0.05,0.02,0.07,1.30, minutes into hours...
gmail??
share Gmail id plz??