Hi all
I'm hoping to work out how to count the number of hours within a single cell, for eg if cell A1 had "10.00 15.00" then cell A2 would have the number "5"
Any help appreciated! I've been searching online so far to no avail.
Thanks
A
Hi all
I'm hoping to work out how to count the number of hours within a single cell, for eg if cell A1 had "10.00 15.00" then cell A2 would have the number "5"
Any help appreciated! I've been searching online so far to no avail.
Thanks
A
Try this
Formula:Please Login or Register to view this content.
v A B 1 10.00 15.00 5
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks so much AlKey!!!
hmmmm only problem now is that half hours in the B1 cell display as .3 rather than .5, which isn't much good if I want to get a total number of hours for a number of these cells. Any thoughts?
Many thanks
I think it would better to convert decimals to real time
Formula:Please Login or Register to view this content.
and format cell as Custom, h:mm
v A B 1 10.00 15.00 5:00
Thanks AlKey - both cells should be formatted as Custom, h:mm? Or just one of them please?
I have 10.00 15.30 in cell A1 and am getting 5:18 in cell B1 rather than 5.50 as I would hope.
(I note 0.18 is 0.30 of 60 so the problem is somewhere there I suppose)
Thank you
Ok, try this
formula in B1 and format as Number
Formula:Please Login or Register to view this content.
Or
v A B 1 10.00 15.00 5.00 2 10.00 15.30 5.50
Formula:Please Login or Register to view this content.
Last edited by AlKey; 05-11-2017 at 12:17 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks